| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Match the Cell From Two Different Columns
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Match the Cell From Two Different Columns
Enter this in C1 and copy down as needed:
=IF(ISNUMBER(MATCH(B1,A$1:A$6,0)),B1) Biff <Nasir Naqvi wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Match the Cell From Two Different Columns
=IF(COUNTIF($A$1:$A$6,B1)0,B1)
Copy down "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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Match the Cell From Two Different Columns
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| MATCH UP DATA IN COLUMNS | Excel Worksheet Functions | |||
| cell color index comparison | New Users to Excel | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
Hybrid Mode
