Assuming data in cols A and B, from row1 down
In C1:
=IF(ISNUMBER(MATCH(B1,A:A,0)),B1)
Copy C1 down to return desired results
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Nasir Naqvi" wrote:
Hi,

How can we match/lookup cell value / variable from "A" cloumn with "B" column. The match value come on "C" column otherwise its FALSE

For Example

A B C
RB123 RB127 RB127
RB124 RB128 RB128
RB125 RB129 FALSE
RB126 RB130 FALSE
RB127 RB131 FALSE
RB128 RB132 FALSE



EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com