Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel VLookup function
- Thread starter qlan
- Start date
79,G2+6,TRUE)
bluedragon2
IS-IT--Management
the +6 adds 6 columns to the value in cell G2.
In other words, if you had 0 in G2, the VLOOKUP formula would retrieve the 6th column of the table if their is a match.
[Blue]Blue[/Blue] [Dragon]
If I wasn't Blue, I would just be a Dragon...
In other words, if you had 0 in G2, the VLOOKUP formula would retrieve the 6th column of the table if their is a match.
[Blue]Blue[/Blue] [Dragon]
If I wasn't Blue, I would just be a Dragon...
It is looking in the column ctrollled by the value in G2. For example, if G2 is 4 then G2 + 6 is 10. So vlookup will look up (value corresponding to value in cell A2) the value in Column J. J being the 10th column in the table.
Member- AAAA Association Against Acronym Abusers
Member- AAAA Association Against Acronym Abusers
- Status