Comparing One Column Against Many Columns, - Displaying matching result..

Hi,

I'm trying to compare (Column H) in Table 2 against Columns A, B, and C in Table 1.

Basically if email address in column H, is an exact match with either column a,b, or c, then in column L, display the corresponding value from column F, if no match, then leave blank.

For reference in column K, i have a formula = IF(OR(ISNUMBER(MATCH(H3,A:A,0)),ISNUMBER(MATCH(H3,B:B,0)),ISNUMBER(MATCH(H3,C:C,0))),"Y","N"),

Which compares column H from table 2 against columns A,B, or C, from table 1, then displays "yes" if it matches, "no" if not a match.

What I'm looking for now is, if it matches either of columns, then do a vlookup...

The desired result is in column L, please see attached file for reference.

Thanks in advance.

I see this over and over again, we need crazy formula because the data is poorly structured. This formula will achieve your purpose:

Please Login or Register  to view this content.

If possible, I recommends your tb1 structure should be like so for efficiency.

First Name Last Name Comments Email Email ID
John Doe Funny [email protected] Email 1
Tee Vee Not Funny [email protected] Email 1
Ray DeeO Very Funny [email protected] Email 1
John Doe Funny [email protected] Email 2
Ray DeeO Funny [email protected] Email 2
John Doe Funny [email protected] Email 3

Seems FlameTetired is still having a problem opening the attachment above.

Dave, see if this helps?

Ford,

That's super. That copy opens fine.

Thank you.
Dave

Edit: And now so does the other one .... Pffft!

Awesome, wonder why the other 1 did not, 6String also did not have a problem

Originally Posted by FDibbins

Awesome, wonder why the other 1 did not, 6String also did not have a problem

Gremlins !!!! It opens now.