{ "media_type": "text", "post_content": "How can I write an if formula that chooses what column to check for based on another cell?\n\nThanks", "post_id": "5f2045e524bc6c0022b421a9", "reply_count": 9, "vote_count": 1, "bowl_id": "5a56f68d15f6ef0013aad256", "bowl_name": "Excel Genius", "feed_type": "bowl" }

How can I write an if formula that chooses what column to check for based on another cell?

Thanks

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

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

like

Tnx. It worked

like

YouTube videos

like

What do you mean “column to check for”?

like

INDIRECT function

like

Offset functions, Google them

like

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

like

Additional Posts in Excel Genius

Anyone get tested for COVID in Manhattan recently and got their results back in a reasonable amount of time? Would like to get tested before I move back in with my parents

like

I used to be passionate about my firm’s people. Loved coaching junior folks and paying it forward with all the great mentoring I received early in my career. But my firm’s values and senior leadership priorities have incentivized a purely numbers vs people culture. It’s made the job so much less fun and personally fulfilling. Anyone also struggling with this and any advice?

likesmart

Always wanted to exit to ACLU but with the SJW attitude being as extreme as it is these days, I'm worried they'll never consider hiring me from big law

like

Any sellers or account managers in the Hybrid Cloud, Data/AI and Automation enterprise solutions groups at IBM?

How has your experience been and challenging is the market for you given your weak offerings for ML.

I ask because I am interviewing for an acc manager role in these teams and I come from a leader in the AI/Ml platform space (DR) but the prospect or working at a tech giant intrigues me.

like

Forming a union. Will we see more big law associates form unions under the Biden administration? What are the pros of forming a union?

likefunnyuplifting

Have you ever said something about/to the receptionist at your office? They are always incredibly distracted on their phone or computer and unprofessional to visitors coming in...

like

I'm going into my first busy season in san antonio, Texas and I'm kinda nervous. What are y'alls busy season hours and what industry is it in?

like

i am begging taylor swift’s graphic designers to turn off the caps lock key. this text box is a typography war crime

Post Photo
likefunny
like

Hello folks,

If I apply from carrers portal of Deloitte USI. Will I get any response from recruitment team. If yes in how many days will they connect?

like

Do we have any watch connoisseurs here? I’m looking to buy a watch to propose with in the <5k range. Anyone recommend anything? None of that glitzy ish like Rolex...looking for craftsmanship. Thanks fam

like

Should we pay for the hotel booking(15 days accommodation provided) if we resign during probation period?

like

Looking for some success stories. My friend transferred a PGA tested embryo but baby stopped growing at 7 weeks - right after hearing the heartbeat. She was initially told that the sac was measuring small and to drink a lot of water. She’s still not sure if that caused the MC. She’s scared of trying again. Anyone have a successful pregnancy after miscarrying a healthy embryo?

like

Does anyone work in digital health marketing? Seeking advice on going in-house from agency side, and breaking into the health care space specifically. Thanks in advance.

like

Got laid off and need a job in Tax urgently.
Spoke to a lot of recruiter but not a lot them sponsor H-1B.

if anyone knows any opportunity, please help

like

Lunch mufat ka rakha hai kya jo khatam ho raha hai? Koi ghar se dabba nahi laaya? 😂

funny

Anyone else in here have ADHD?

like

What is the hierarchy of EY GDS? What’s the next level after Technical Lead - Rank 42 ?

like

Any Zomato millionaries out here?

like

Curious to hear thoughts from any attorneys at Jackson Lewis NYC about their experience at the firm.

like

Additional Posts (overall)

I have a giant excel that won't open. Any tips on how to fix this

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Hello! Is there anyone who can give me the steps to show cents in excel? For example I need 2911402 to show as $29114.02

like

How can I index match a relative value?

I want to look up the per unit cost of 280M units, but don’t have an exact match. The numbers in the picture below are actual units/infra I’m searching against

My formula is currently =index(D26:D48,match(B56,B26:B48,1)

Post Photo
like

Any ideas on how to sumif based on criteria listed under a given header wherein the header is the main reference but there are varying criteria beneath said header? Specifically, I would like to drag a formula down a column that references a corresponding department in the row (the header on a sep sheet) and then sums the listed accounts beneath each dept (with each dept having a diff # of accounts) from a given data set. Could do a pivot, but the filtering process is inefficient.

like

I have a crappy spreadsheet that I’m trying to make more appealing or easier to digest. What would be the best way to do so? I have locations, first name, last name, start date, end date, dob, and comments as the rows and columns have the details. I’m trying to get the dates to show up in the pivot chart instead of a value of that makes since. What would be the way to go about this.

like

What’s your favorite way to do a notes tab? I was using [00] to number them and then using hyperlinks but they break if I want to move the note around. I’d like a way to navigate to and from.

like

Does anybody know what the +0 function does in a vlookup? I can send a formula for a better explanation if that would help. When I don’t include it, I get error returns from the lookup list...but with it I get a correct return from the list.

like

Excel's Conditioning Formatting has a mind of it's own, or is possessed. You define the rule, designate the reference cell/range (goodness knows NOT to use arrow keys within the Edit Rules box... cont

like

I have many DAT files that need to be converted to excel workbooks by using delimited. Does anyone know how to automate that process rather than having me convert each DAT file manually? Trying to save some time here as a newbie 😢

like

How to apply conditional formatting across tabs in excel sheet? In a drop down data validation I have A (Green) B (Blue) and C (Red). I selected the cells I want to apply, hit format painter and then selected the cells where I want to apply on next tab but not everything carries. Wondering if any tips on what I’m doing wrong

like

For those with MS suite, any apps you’d recommend in addition to standard Outlook, Word, Excel, Powerpoint, Teams? Milestones was OK, but Tasks seemed a useless.

like

Is Copy, Paste Link the same as =“randomCell”
I noticed when I pasted cell and came back to it, it would show ref errors where as the =“randomCell” would be okay

like

Trying to use power query but it can’t find a connection in excel, saying the external component has thrown an exception. Any ideas?

How do I stop excel from changing the cell reference to a different column each time I refresh the data pull?
The spreadsheet is connected to an API data pull. Each time I refresh the data it changes the cell reference (SCD_0010) to a different cell e.g. (SCD_0127). How can I stop this?

Post Photo
like

I have a data set of ~500 restaurants. I want to sum the total order value for each restaurant. What formula can I write to only add the order value (red column) for each restaurant (orange column eg 1,2,3,4). I want to lay out this data on a graph to see which restaurants generate the most revenue. Any tips?

like

Possible to use conditional formatting to highlight cell in the table that matches the output of the calcs in column C when the assumptions in row 7 and 8 are changed?

Post Photo
like

Anyone familiar with the fuzzy match add in, and if so, how do you run a fuzzy match within one column of information rather than two tables? I.e., I want to find close matches within one list of vendor names

likesmart

Does anyone know the best approach when dealing with Ad sales linear and digital in Analytics? Or any knowledge about the ad sales industry

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
Download Fishbowl to see what others are saying
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

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

New to Fishbowl?

image with Fishbowl logo and arms reaching out for a handshake

Already have an account? Log in

By continuing you agree to Terms of Use and Privacy Policy.
Messaging rates may apply

For account settings, visit Fishbowl on Desktop Browser or

General

Legal