How to use vlookup for microsoft Excel?
Monday, July 2, 2012
Wondering how to use vlookup to search for a value?
Scenario 1:
Search a target cell to find out the existance from another column.
In the example above, we use the formula
=VLOOKUP(D3,B:B,1,FALSE)
we are searching cell D3 ('C') against column B (B:B), if exist, return value from B#, FALSE is to find exact match.
Scenario 2:
Search a target cell E8 ('D') against column B8:C10, if exist, return the value from column C.
=abs(h8-f8) to get the differences. ABS value of 0 means E9 value of 5 equivalent to B9 value of 5.
0 comments: to “ How to use vlookup for microsoft Excel? ”
Post a Comment