How can I write an if formula that chooses what column to check for based on another cell?
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
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?
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
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.
Forming a union. Will we see more big law associates form unions under the Biden administration? What are the pros of forming a union?
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...
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?
i am begging taylor swift’s graphic designers to turn off the caps lock key. this text box is a typography war crime
How is health,Life insurance and other benefits there in BNY Mellon | Pershing
Is parents insurance coverage included?
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?
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
Should we pay for the hotel booking(15 days accommodation provided) if we resign during probation period?
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?
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.
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
Anyone else in here have ADHD?
Any Zomato millionaries out here?
Curious to hear thoughts from any attorneys at Jackson Lewis NYC about their experience at the firm.
Additional Posts (overall)
What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?
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
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)
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.
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.
What’s your favorite way to do a notes tab? I was using  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.
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.
2022 Financial Modeling World Cup Stage 1 results are in.
Sign up - cash prizes to the top participants! (Your bottom 2 stages do not count towards your yearly score so there is still time)
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
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 😢
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
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.
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
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?
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?
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?
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
Does anyone know the best approach when dealing with Ad sales linear and digital in Analytics? Or any knowledge about the ad sales industry
New to Fishbowl?
unlock all discussions on Fishbowl.