Additional Posts in Excel Genius
Anyone else in here have ADHD?
Any Zomato millionaries out here?
Additional Posts (overall)
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
Anyone else in here have ADHD?
Any Zomato millionaries out here?
Send download link to your phone
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Download the Fishbowl app to unlock all discussions on Fishbowl.
Copy and paste embed code on your site
Hard to tell exactly what you’re trying to achieve, but I’ve done plenty of Index Match Match combos where the Matches refer to Data Validation dropdowns to determine the cells they’ll pull values from
Tnx. It worked
YouTube videos
What do you mean “column to check for”?
INDIRECT function
Coach
Offset functions, Google them
Tnx
To clarify I have a column with an if formula that checks the status of another column. I want that column to be dynamic so I can change one cell and the column the if statement checks changes
So in cell D3 ill have drop down of apples, oranges, ice cream
And then column c will do a check of column a if its apples and column b if its ice cream etc
Sounds like you might be able to get what you want if you do what I said above except nest the IF statement you’re talking about in the Index Match instead of adding another Match, unless I’m still misunderstanding