M
ma
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
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