Forum Discussion
VLOOKUP to the left
Hi, I have windows 10 and Excel 2016 I came across this formula on for VLOOKUP to the left but didn’t understand it VLOOKUP(F7,IF({1,0},D:D,B:B),2,0) In both these cases the...
VLOOKUP(F7,IF({1,0},D:D,B:B),2,0)
F7=lookup value
IF({LOOKUPCELL IS TRUE(1),0},THEN LOOKUP RANGE=D:D, RETURN RANGE=B:B ELSE IF IT IS BLANK RETURN A ZERO
range D:D = lookup range
range B:B = return value range
2= can only be a value of 2 or 1
0= exact match