| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Comparing 3 Columns and Returning a Result
Hello.
I have 3 columns I want to compare, A, B & C. All the values are text values. What formula would I use if I want to determine the following: If a value in column A is found in column B, then return the value in column C (which corresponds to column B) and place in column D. When I attempted to write the formula using the IF logic, it only worked when the values in columns A & B were on the same row. This, however, is not the case for all rows. There are more unique values found in B then in A. Example A B C D Apple Banana Yes No Banana Apple No Yes Grape No |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Comparing 3 Columns and Returning a Result
Hi,
=index($C$1:$C$1000,match(a1,$B$1:$B$1000,0)) "ma" wrote: Hello. I have 3 columns I want to compare, A, B & C. All the values are text values. What formula would I use if I want to determine the following: If a value in column A is found in column B, then return the value in column C (which corresponds to column B) and place in column D. When I attempted to write the formula using the IF logic, it only worked when the values in columns A & B were on the same row. This, however, is not the case for all rows. There are more unique values found in B then in A. Example A B C D Apple Banana Yes No Banana Apple No Yes Grape No |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Comparing 3 Columns and Returning a Result
Thank you!
"Eduardo" wrote: Hi, =index($C$1:$C$1000,match(a1,$B$1:$B$1000,0)) "ma" wrote: Hello. I have 3 columns I want to compare, A, B & C. All the values are text values. What formula would I use if I want to determine the following: If a value in column A is found in column B, then return the value in column C (which corresponds to column B) and place in column D. When I attempted to write the formula using the IF logic, it only worked when the values in columns A & B were on the same row. This, however, is not the case for all rows. There are more unique values found in B then in A. Example A B C D Apple Banana Yes No Banana Apple No Yes Grape No |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing 1 number to 1000's and returning corresponding name | Excel Discussion (Misc queries) | |||
| Returning a text result from 2 lookup columns | Excel Discussion (Misc queries) | |||
| comparing columns and returning max value | Excel Discussion (Misc queries) | |||
| comparing two lists and returning value from different column | Excel Worksheet Functions | |||
| Comparing databases and returning values | Excel Worksheet Functions | |||
Linear Mode
