Start Free Trial
Vlookup three columns
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
8/22/2022 - Mon
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.
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!
In that case:
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
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
ASKER CERTIFIED SOLUTION
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.
I used the editor, maybe i changed it somehow, anyhow, it works!
Plans and Pricing
Certified Expert Program
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent