VLOOKUP Problem

A

andyp161

FALSE in VLOOKUP is for some reason returning values that do not exist.
However, when I use TRUE, those values which FALSE is erroneousl
returning are replaced by the nearest match. Therefore, TRUE i
working as it should, but FALSE is not?? Please help, for this i
driving me crazy!!!

Kind regard
 
A

Andy B

Hi

Maybe you are searching for numbers and the cells are not formatted to
display them correctly - so it looks like the wrong results are being
returned. Post some sample data (in plain text) and your formula.
 

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

Multiple VLOOKUP in an IF statement 2
Searching the formula (not the value) for a text string 1
Help With VLOOKUP 2
Vlookup Returning Zero For Every Cell 3
VLOOKUP & Data Validation 0
vlookup formatting problem 1
Dragging a formula down isn't working - where am I going wrong? 1
Vlookup returns #N/A when Range is 'false', but returns values when 'true' 4

Top