vlookup

  • Thread starter Thread starter fc
  • Start date Start date
F

fc

I use =vlookup(A5, A2:A4, 2) and the output is #REF! but
if I use =vlookup(A5, A2:A4, 1) it will show "achan".

A2=achan, A3=bchan, ..
B2=1, B3=2...
A5=achan

anything I am missing?
 
That is because you ask vlookup to look in the second column while only
providing one column

=VLOOKUP(A5,A2:B4,2)

will work

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Back
Top