Hi Roly,

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


"roly" wrote:


Hi,

Can you give us a bit more information please - I or somebody else
should be able to help.

All the best,


Roly


--
roly
------------------------------------------------------------------------
roly's Profile: http://www.excelforum.com/member.php...o&userid=24631
View this thread: http://www.excelforum.com/showthread...hreadid=401194