Comparing 3 Columns and Returning a Result

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Date diffrence in days, weeks and months. 1
Use a variable in a ShapeRange.Increment 0
Help with column accumulation needed 2
Incorporating the User Profile location into a document template path 1
lookup and return column number 2
Copy addition formula of non-consecutive horizontal cells 2
Comparing two columns and returning value from another column 1

Top