Sample excel file is attached
I need a formula that essentially analyzes cells A3 and B3 of Sheet "IO", based upon the table in Sheet "DATA" and outputs the results to Cell C3.
(ex. On Sheet "IO", A value in cell A3 of $8,500.00, and a value in cell B3 of 31% would output a value of $125.00 in C3).
Hopefully this makes sense. I filled the first few cells in manually to hopefully get someone going in the right direction.
Thanks so much!
Last edited by Sheldon91399; 08-10-2023 at 10:00 AM.
They key here is to make your % and $ brackets numbers instead of text. I modified your table to show the minimum percent for each column, and minimum $ for each row. Then it's a simple INDEX/MATCH/MATCH formula to look up the numbers in the table.
That was it, thanks!
Last edited by Sheldon91399; 08-10-2023 at 10:00 AM.
You're welcome and thanks for the rep!
BTW I found your title confusing. What you have in your file is a data table, not a chart.
Yeah I realized I messed that up shortly after I posted. I was gonna change it but you were so quick to the punch that I did not get a chance to lol!
Last edited by Sheldon91399; 08-10-2023 at 10:00 AM.
Sheldon - would you please update your forum profile with the 'latest' version of Excel that you have? Is it Excel 2021 or 365? Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Absolutely, I just updated it.
Perfect - thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks