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.
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.