Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a Quick answer on this one.........
I have three columns of numbers....I need to find exact matches between 2 of
them. If a match is found I need to copy a number from the other column to an empty column. For example, if any number in column B matches any number in column C, then copy the number in A (next to the match it found in B) to column D. I hope that makes sense. Thanks, Dan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a Quick answer on this one.........
Try,
=IF(A1=B1,C1,IF(A1=C1,B1,IF(B1=C1,A1,"No Match"))) Untested, but should work. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a Quick answer on this one.........
Are you talking about any cell in COLUMN A matching any Cell in COLUMN
or C Mat -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a Quick answer on this one.........
On possible "quick" solution might be the following. However, this returns
an #N/A error if all numbers are unique. Not sure how you want to handle that. This looks at the three numbers in A1:C1 =SUM(A1:C1)-2*MODE(A1:C1) HTH Dana DeLouis "Dan B" wrote in message ... I have three columns of numbers....I need to find exact matches between 2 of them. If a match is found I need to copy a number from the other column to an empty column. For example, if any number in column B matches any number in column C, then copy the number in A (next to the match it found in B) to column D. I hope that makes sense. Thanks, Dan |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a Quick answer on this one.........
Thanks for all the help. After some rearranging of data, and help from
another post, I got it to work with this formula: =IF(ISNA(VLOOKUP(C4,A$4:B$10,2,FALSE)),0,VLOOKUP(C 4,A$4:B$10,2,FALSE)) Thanks to all! "Dan B" wrote in message ... I have three columns of numbers....I need to find exact matches between 2 of them. If a match is found I need to copy a number from the other column to an empty column. For example, if any number in column B matches any number in column C, then copy the number in A (next to the match it found in B) to column D. I hope that makes sense. Thanks, Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PLEASE HELP!! NEED QUICK ANSWER AS HAVE TO HAND IN SPREADSHEET ASA | New Users to Excel | |||
Help! Need A Quick Answer Please! | Excel Discussion (Misc queries) | |||
Quick answer please! | Excel Worksheet Functions | |||
two quick questions on excel. please answer as soon as possible... | Excel Worksheet Functions | |||
Simple Question, need quick answer please | Excel Programming |