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!
 
Never mind, it appears the list has to be sorted ascending (even though the
last value is FALSE).

All fixed, thanks anyway.
 
Back
Top