Vlookup three columns

Hi,

I have one excel tab with a load of data in column F

I want to check if there is corresponding values in three other tabs.

The corresponding values are always in Column A

How can i check this as a Vlookup will only return from one tab

Thanks
Seamus

Microsoft Excel

Last Comment

Seamus2626

8/22/2022 - Mon

Rory Archibald

3/15/2012

Do you want to check if there is data in one of the three, or all three? You'll basically need three separate vlookups, either nested or concatenated depending on the answer to my question.

Seamus2626

3/15/2012

ASKER

They could be a corresponding value in tab one, two, or in all three or no match at all

I need to return text "Match" if there is a corresponding value in tab one, two, or all three
&

Text "Non Match" if there is no corresponding value in any of the tabs

Hope that makes sense!

Rory Archibald

3/15/2012

In that case:

=if(count(match(a1,sheet1!a:a,0),match(a1,sheet2!a:a,0),match(a1,sheet3!a:a,0))>0,"match","no match")
for example

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat

William Peck

Seamus2626

3/15/2012

ASKER

Hey Rory, i have zipped the file which i am working on and have tried to implement your formula as you will see in Tab ASPA

Can you see why that cant see what is a match as a match?

e.g B2 should be a match

Thanks
Seamus
ASPAMatch.zip

ASKER CERTIFIED SOLUTION

Rory Archibald

3/15/2012

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Seamus2626