vlookup

[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?

 

[Peo Sjoblom]

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