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? |
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) |