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

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

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