Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup returns wrong answer (off by one row)
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup returns wrong answer (off by one row)
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_loo kup) =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 "BAA" wrote in message ... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup returns wrong answer (off by one row)
If you have many things in the range is there something that you can put in
the range lookup to decipher it from others? "Peo Sjoblom" wrote: 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_loo kup) =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 "BAA" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cosine Function Returns Wrong Answer! | Excel Discussion (Misc queries) | |||
VLOOKUP Formula Returns the Wrong Results. | Excel Worksheet Functions | |||
Using Indirect in a Sumif Function returns the wrong answer | Excel Discussion (Misc queries) | |||
Vlookup Returns Wrong/No Data | Excel Worksheet Functions | |||
Logic statement returns wrong answer. | Excel Worksheet Functions |