VLookup not returning the last value

  • Thread starter Thread starter George
  • Start date Start date
G

George

Hello,
I am using VLOOKUP =VLOOKUP(D7,X4:X7:Y4:Y7,2,FALSE)
My problem is that X7 is not showing in the dropdown list.
The dropdown is simple text a value just like the other rows.
Can anyone help me understand why I don't see this value?

Thanks very much!
 
VLOOKUP(D7,X4:X7:Y4:Y7,2,FALSE)
try
VLOOKUP(D7,X4:Y7,2,FALSE)
 
Never mind, it appears the list has to be sorted ascending (even though the
last value is FALSE).

All fixed, thanks anyway.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't Explain N/A in Vlookup 2
VLookup Function HELP 7
Second to last entry 4
VLookup not working - missing entries or not returning correct values 1
Finding value using greater than, Vlookup, and nested If 2
VLOOKUP Problem in EXCEL 2010 3
#REF error with Vlookup 1
#REF with vlookup 1

Back
Top