VLOOK up fails! [Solved/Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

this is the code that i have:

=VLOOKUP(C2,'sport'!I:L,1,FALSE)

Where C2 can be varied, depends on user input.

the column containing the word typed in cell C2 should be located at column L in the worksheet "sports" and i want the matching data in column I to be shown.

I have already converted all data into text format but the vlook up is still not working and returning a /na.


Please help!!
Related:

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
suggest second argument make it absolute so that the formula can be used any other value in column C by copying C2

third argument
the reference values of C2 and similar should be in the first column of second argument reference range.
the second argument is 1 that means same as c2 value which is in column I (It is not value in column J in that case the argument is 2 and not 1. in offset it is one step to the right but in vlookup the columns are counted from the first column in the reference range(that is second argument I:L in your case)

please again read vlookup.

perhaps your data sheet in sport sheet is different. copy a small portion in your replly and the value of C2 in the first sheet where formula is paraked

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!