Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing cloumns and write answer in third
I am sure this is an easy task, but at the moment I don't know where
to start. I have an excel file with 2 tabs. In tab 1 I have 580 lines with numbers: Col1 col2 col3 1 80074635 2 80073639 3 93648329 .. .. .. 580 80038938 ============ In tab 2 I have 560 lines: Col1 col2 1 80083476 2 80037363 3 83630923 .. .. .. 560 89237383 =========== I want col3 in tab1 to have the value/text "YES" if the corresponding number in col1 in tab1 exists ANYWHEREin col2 of tab2. If not the text should be "NO" What should I use to do this and how? I am not so experienced in Excel so would appreciate to-the-point solutions. BH |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing cloumns and write answer in third
Small error:
"I want col3 in tab1 to have the value/text "YES" if the corresponding number in col2 in tab1 exists ANYWHEREin col2 of tab2. If not the text ^^^^^^ should be "NO" " On 11 Mai, 10:42, Oladunk wrote: I am sure this is an easy task, but at the moment I don't know where to start. I have an excel file with 2 tabs. In tab 1 I have 580 lines with numbers: Col1 col2 col3 1 80074635 2 80073639 3 93648329 . . . 580 80038938 ============ In tab 2 I have 560 lines: Col1 col2 1 80083476 2 80037363 3 83630923 . . . 560 89237383 =========== I want col3 in tab1 to have the value/text "YES" if the corresponding number in col1 in tab1 exists ANYWHEREin col2 of tab2. If not the text should be "NO" What should I use to do this and how? I am not so experienced in Excel so would appreciate to-the-point solutions. BH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data merging from two cloumns into one | Excel Discussion (Misc queries) | |||
how to seperate cell contents into two cloumns ? | Excel Discussion (Misc queries) | |||
answer to odd results when comparing hyperlink addresses | Links and Linking in Excel | |||
comparing data and write values if true | Excel Programming | |||
Pivottable total cloumns | Excel Programming |