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.


AddThis Social Bookmark Button
Email this post


Design by Amanda @ Blogger Buster