vLookup Multiple Columns

[a-w]

Hi Guys,

I need help...

I have a list of e-mail addresses in one sheet and I want to see if they exist in two columns on a different sheet. If they address does exist, I want to put a "Y" in the match column.

Example attached.

Any help would be great.

Cheers,

a-w

[gjlindn]

Hello a-w. It's not all that elegant, but this would work. Paste it in cell B2 and copy down.

Please Login or Register  to view this content.