Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing 2 columns for matches
Hi, I have 2 columns with data (lets say A and C). I want to (in another
column, say B) put a formula in that finds if a value in column A and looks to see if there is a match in column C (not necessarily on same row). If there is a match I want to input a value which exists in a 4th column in the same row as the matched value in column C. e.g: Col A Col B (formula here) Col C Col D dog No match bear xxx cat No match mouse vvv mouse vvv lion xxx So...if a value from column A exists in Col C (e.g. mouse) then in column B i want to extract the value from col D (e.g. vvv), otherwise say 'no match'. So both two and three. Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing 2 columns for matches
Assuming in your example the data is in cells A1 through D3, the following
formula should work: =if(iserr(vLookUp($A1,$C$1:$D$3,2,false)),"No Match",vLookUp($A1,$C$1:$D$3,2,False)) Good Luck "Burt" wrote: Hi, I have 2 columns with data (lets say A and C). I want to (in another column, say B) put a formula in that finds if a value in column A and looks to see if there is a match in column C (not necessarily on same row). If there is a match I want to input a value which exists in a 4th column in the same row as the matched value in column C. e.g: Col A Col B (formula here) Col C Col D dog No match bear xxx cat No match mouse vvv mouse vvv lion xxx So...if a value from column A exists in Col C (e.g. mouse) then in column B i want to extract the value from col D (e.g. vvv), otherwise say 'no match'. So both two and three. Is this possible? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing 2 columns for matches
Couldn't figure out why it wouldnt work, but as soon as I had changed it to
'iserror' then it worked perfectly. Thanks for the formula Cheers, "ND Pard" wrote: Assuming in your example the data is in cells A1 through D3, the following formula should work: =if(iserr(vLookUp($A1,$C$1:$D$3,2,false)),"No Match",vLookUp($A1,$C$1:$D$3,2,False)) Good Luck "Burt" wrote: Hi, I have 2 columns with data (lets say A and C). I want to (in another column, say B) put a formula in that finds if a value in column A and looks to see if there is a match in column C (not necessarily on same row). If there is a match I want to input a value which exists in a 4th column in the same row as the matched value in column C. e.g: Col A Col B (formula here) Col C Col D dog No match bear xxx cat No match mouse vvv mouse vvv lion xxx So...if a value from column A exists in Col C (e.g. mouse) then in column B i want to extract the value from col D (e.g. vvv), otherwise say 'no match'. So both two and three. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count matches within two columns | Excel Discussion (Misc queries) | |||
comparing matches | Excel Discussion (Misc queries) | |||
Counting matches from more columns | Excel Worksheet Functions | |||
I need to compare to columns and indicate the matches in another | New Users to Excel | |||
Comparing 2 column for matches | Excel Discussion (Misc queries) |