PDA

View Full Version : [SOLVED] Issue with VLOOKUP.....Working on 1 Cell but not the other cell....



enggrahul78
09-09-2019, 01:34 PM
I have 2 sheets. I am using first sheet , to look a record in 2nd sheet and bring back some value from 2nd sheet to 1st sheet.

Problem is that if 1 give a lookup range as B1:D3 my VLOOKUP works ,but if i change the range to B1:D7 it will no work. This is weird. Attached excel contains all the details.

Paul_Hossler
09-09-2019, 02:48 PM
Add 'FALSE'

24984

Artik
09-09-2019, 03:05 PM
If you do not specify the last parameter [range_lookup], then the default value is TRUE, i.e. approximate match. To use approximate match, the values in the first column of the range must be sorted.
Set the last parameter to FALSE.

..::Edit
Eh, I'm a little late :) ::..

Artik

enggrahul78
09-09-2019, 03:32 PM
Thanks Paul and Artik.