Match the Cell From Two Different Columns

[Nasir Naqvi]

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

 

[T. Valko]

Enter this in C1 and copy down as needed:

=IF(ISNUMBER(MATCH(B1,A$1:A$6,0)),B1)

Biff