Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare two col data & add info
Is there anyone know how I can compare the following data in Excel spread sheet
When comparing col A & Col C, If A2 (tp-2) =C4 (tp-2) then put D4 (deleted) in B2 A B C D 1 TP-1 TP-3 new 2 TP-2 deleted TP-5 xx 3 TP-3 new TP-8 4 TP-4 TP-2 deleted 5 TP-5 xx TP-10 Please help & many thanks Philip |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare two col data & add info
Let's see if I understand you correctly...try this:
B1: =IF(ISNA(VLOOKUP(A1,$C$1:$D$5,2,0)),"",VLOOKUP(A1, $C$1:$D$5,2,0)) Copy that formula down to B5. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "philip" wrote: Is there anyone know how I can compare the following data in Excel spread sheet When comparing col A & Col C, If A2 (tp-2) =C4 (tp-2) then put D4 (deleted) in B2 A B C D 1 TP-1 TP-3 new 2 TP-2 deleted TP-5 xx 3 TP-3 new TP-8 4 TP-4 TP-2 deleted 5 TP-5 xx TP-10 Please help & many thanks Philip |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare two col data & add info
Ron,
It work very good, thank you very much, would you mind explain to me how it work?? philip "Ron Coderre" wrote: Let's see if I understand you correctly...try this: B1: =IF(ISNA(VLOOKUP(A1,$C$1:$D$5,2,0)),"",VLOOKUP(A1, $C$1:$D$5,2,0)) Copy that formula down to B5. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "philip" wrote: Is there anyone know how I can compare the following data in Excel spread sheet When comparing col A & Col C, If A2 (tp-2) =C4 (tp-2) then put D4 (deleted) in B2 A B C D 1 TP-1 TP-3 new 2 TP-2 deleted TP-5 xx 3 TP-3 new TP-8 4 TP-4 TP-2 deleted 5 TP-5 xx TP-10 Please help & many thanks Philip |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare EE #s & Copy Info | Excel Discussion (Misc queries) | |||
Compare and group like numbers and info | Excel Worksheet Functions | |||
How do I compare info in on sheet to info in another? | Excel Discussion (Misc queries) | |||
compare info in 4 worksheets and highlight fields that are the sam | Excel Worksheet Functions | |||
compare columns of info | Excel Discussion (Misc queries) |