Vlookup formula Excel version 2002
 

I want column A to be the lookup column and compare to column B. The results
in column C will be the row items that are equal in both columns A & B. I
need a vlookup formula for this.

Example:

Column A
1
11
2

Column B
2
35
8
11

Column C (Vlookup formula Results)
2
11

In addition if you are able to give me the vlookup formula for the ablove,
is it possible to use column A as vlookup & compare against 2 other columns
at the same time (i.e. column D & E) to check if there are similar row items
in columns D & E?

Thanks

--
biz

--
biz