Excel 2002 SP3
Win XP HE SP1

*Follow-up group is: microsoft.public.excel* *only reply to:
microsoft.public.excel*

hi,
i am having a problem with vlookup wherein if i use formula A:
=VLOOKUP(A2,NJ!$C$2:$C$48,1, FALSE) it works but formula B doesn't:
=VLOOKUP(A2,NJ!$A$2:$E$48,5,FALSE)
the only difference is the table array range which in the formula B
looks into the same sheet etc., but at more columns.
i can't understand what is causing the problem.
i believe that the columns do not need to be sorted (help file); the
sheets are formatted properly, etc.
i've done LOTS of vlookups in really complex spreadsheets in the past
but am rusty right now and can't put my finger on what i am doing wrong.
anyone can help?

You sure
=VLOOKUP(A2,NJ!$A$2:$E$48,5,FALSE)
shouldn't be:
=VLOOKUP(A2,NJ!$c$2:$E$48,3,FALSE)

(so the key looks to match column C).



stef wrote:

Excel 2002 SP3
Win XP HE SP1

*Follow-up group is: microsoft.public.excel* *only reply to:
microsoft.public.excel*

hi,
i am having a problem with vlookup wherein if i use formula A:
=VLOOKUP(A2,NJ!$C$2:$C$48,1, FALSE) it works but formula B doesn't:
=VLOOKUP(A2,NJ!$A$2:$E$48,5,FALSE)
the only difference is the table array range which in the formula B
looks into the same sheet etc., but at more columns.
i can't understand what is causing the problem.
i believe that the columns do not need to be sorted (help file); the
sheets are formatted properly, etc.
i've done LOTS of vlookups in really complex spreadsheets in the past
but am rusty right now and can't put my finger on what i am doing wrong.
anyone can help?

--

Dave Peterson