vlookup returns wrong answer (off by one row)

  • Thread starter Thread starter BAA
  • Start date Start date
For future posts put the question the body ofg the message.

Sounds like you are using no range lookup value

=vlookup(lookup_value,table,column_index_range_lookup)

=vlookup(a1,b2:c50,2,false)

if you don't use false (or zero) it will need the leftmost column sorted in
ascending order
and false also makes it look for the exact value and will return an error
otherwise but leaving it out or using true will lookup the largest value
less than or equal to the lookup value


--


Regards,


Peo Sjoblom
 
If you have many things in the range is there something that you can put in
the range lookup to decipher it from others?
 
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

Why is VLOOKUP returning a value from the row above? 7
Vlookup - Returning 2nd match 4
Vlookup and return sheet name also 2
VLookup Data, Find 2 Adjacent Rows, Return Value in 1 Row 3
VLOOKUP returns unwanted/wrong values 4
VLOOKUP return cell location and hyperlink 0
Returning Multiple Results with Vlookup 1
vlookup returns na 7

Back
Top