Is there any way to compare multiple index match formulas. Looking to find a match across three different tables on three different tabs. Most I’ve seen is using if error to compare 2.

like
Posting as :
works at
You are currently posting as works at

Is there an identifier you can use to direct it to the right index? E.g. if you had categories XYZ on tables ABC:. if(category = X, index match on table A, if (category = Y, index match on table B, index match on Table C))

Can you nest another ifferror in there if that doesn't work? E.g., iferror (Index match on Table A, iferror (Index match on table B, index match on table C))

You’ll either need to put all tables in PowerQuery or use the indirect function

Can you not use AND()?

Or do you mean criteria exists in three locations and you're just trying to pull from a single array?

This may not be the best option for performance but you could use nested Xlookups if you have the functionality. It would do the same as your iferror formula but as many times as you would want. It will take forever to process on a large dataset, though.

Related Posts

I saw Alteryx down 10% today. I feel like AYX will destroy upcoming earnings. Speaking from user side, it’s being pushed upon employees to cut down labor cost and it’s pretty user friendly. They are even teaching is in college data analytics classes. Anyone have any opinions on it?

like

When do you start negotiating salary in the interview process especially if you already have an offer? After the final interview or when you actually get the offer?

like

What are some quite coffee shops to crank out work in Manhattan?

like

Best Math Curriculum for SPED Math Class 5-8. My School provides me nothing.

like

Anyone else have white coat syndrome? Whenever I go to the Dr my BP shoots up through the roof cos my anxiety is really bad. When I go home and test it, I get normal values. I feel really stupid and don't know anyone with this weird problem.

like

It baffles me every day that people have unprotected sex with people they don’t like. No condom, no plan B, no common sense. Now I have to be here paying bills.

likefunny

Hello All,

I completed the PG Program in Management from Institute of Management Technology, Ghaziabad now. Can I get referral jobs.
Thank you.

like

Is LMS working fir anybody?

like

Anyone hiring a mid-level AD in Chicago?

Anyone ever have Investment Drawbacks and how the company addresses those drawbacks on a CIM? I've heard buyers liked it when there's upfront highlights and drawbacks.

like

PwC I think our (up to) $20,000 referral bonus (for getting in a senior manager/director to the global mobility services group) seems to show more a sign of desperation especially as competitors offer $3,000-$4,000 for a senior manager referral bonus. What’s the deal?
Have a certain number of that experience level been promised in the sale of the practice?

like

Hey All, I am 4 years of experience in IT (1 year on cloud/DevOps and 3 years in L2 Application Support). I'm at L3 currently and working on AWS, git, jenkins, MySQL, Docker, Monitoring and a bit security also.

I need your advice if should go for L3 only or L4 also? How much should I expect? current CTC is 10.

Amazon cloud support engineer role would be good? Or similar roles in other product based companies?

Thanks in advance.

like

Curious of your top 3 LCHF podcasts you find helpful????

like

What is the probation period in intuit for lateral joinees??

like

Hello- what are the benefits of kitting in EWM vs. ECC??? Like I know EWM has Kitting Processes Sat up!

like

Currently on vacation in Warsaw, Poland. So far, I've had a 40m airport train ride for £0.90, a three course meal with drinks for £9, and a doughnut bigger than my head for £0.50. What a great town.

like

Hi all, I was joined 28 Jun in CTS with 4lpa, yet I am in project but the kt sessions also not started yet and so many are suggesting to change the company bcz of layoffs, is that layoffs are real or not ?

like

I am having 12.5 lpa CTC with 7.7 YoE. How much can Delta Airlines offer?

like

Just get to know that one of the candidate got 20.5 LPA plus 2 lakh bonus for SA-2 position in assurance department. He was asking me if they paid him less 😪

Additional Posts in Excel Genius

Why does my excel always freeze when I copy a cell?

like

Will index match fall by the way side with the Advent of xlookup?

like

Been in consulting for over a year and wondering what other formulas other than index/match and vmatch is useful.

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

I’m experiencing a delay when I switch between different workbooks where it would take at least 5 seconds until I can click into the new workbook. I’m losing productivity especially when I’m doing a copy and paste task between different spreadsheets. Anyone else experienced this before and know any potential solutions?

like

I use both excel and google sheets, and love them both for different reasons, but they don't agree on which direction decimal rounding goes and it makes me crazy

Post Photo
likefunny

What are PowerQuery and PowerPivot truly good for?

like

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

like

I have multiple sheets with same columns that I want to combine in a single sheet within the same workbook without having to copy paste . They all have same column names and each one has a header row. How to do this ?

likesmart

Noob here:(
Lead wants me to limit values in 5 columns - achieved
Now she wants me to implement - If 1st column is filled and others' are empty, raise an error. Tried ISBLANK but it removes drop-down

like

Hello again fishies...

Column D in tab 1 and tab 2 is a drop down list which has 6 items.

In tab 3 how can I return the Cells in Column a b and c (tab 1 and 2) when the value in cell d(tab 1 and 2) is one of the 6 items selected

like

Change my mind

Post Photo
likefunny

Need help tabulating survey results. Each row is a respondent, but the question asks “choose all that apply” resulting in several columns associated with that one question. How can I get a distribution for which answers were chosen among the top 3?

like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Does anyone else find it frustrating when co-workers find out that you’re good at Excel, they feel the need to ask you how to do EVERYTHING, how to data sort, how to use basic functions and try to pawn off work to you because “your proficient in Excel so you’ll get the job done faster??”
I didn’t mind helping at first, I’ve started telling them to start googling it or saying “I’m not sure how to use SUMIF 🙃”

likefunny

SUMIFS wildcard question: is there a way to pick up values based on the cell containing a wild card? (So not an in formula wildcard)
Example: I have scenario A1, A2, & B1
Some criteria apply to both A1 & A2, and I would like to not duplicate the criteria. So when the user selects scenario A1, I want to pick up criteria A* & A1, but not A2. For selecting scenario A2, I want to pick up criteria A* & A2, but not A1.

like

Just got a new personal laptop. Is there a good way to get Microsoft Office for free? I’m looking for a download rather than the subscription usage

How do you create a Pareto chart in excel? Like I want to identify what percentage of customers contribute to 80% sales. I have data at individual customer level.

like

Do you still use index match? Is it (Always) Possible to switch to xlookup?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal