I want to add a formula in J5 that will find the value of (G5 (which =14) in the table and return the value from 2 cells below (6322.47) Screen Shot 12-11-19 at 10.29 AM.JPG
I want to add a formula in J5 that will find the value of (G5 (which =14) in the table and return the value from 2 cells below (6322.47) Screen Shot 12-11-19 at 10.29 AM.JPG
Last edited by gigglezallday; 12-11-2019 at 12:33 PM.
If those numbers are always arranged like that, you *could* cheat like this:
WBDPlease Login or Register to view this content.
Office 365 on Windows 11, looking for ✶ rep!
this works at least based on my best guess as to the cells involved...
=IF($G$5<=13,INDEX($A$10:$M$10,MATCH($G$5,$A$8:$M$8,0)),IF($G$5<=26,INDEX($A$14:$M$14,MATCH($G$5,$A$12:$M$12,0)),IF($G$5<=39,INDEX($A$18:$M$18,MATCH($G$5,$A$16:$M$16,0)),IF($G$5<=52,INDEX($A$22:$M$22,MATCH($G$5,$A$20:$M$20,0)),""))))
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
WideBoyDixon, thank you, thank you, thank you. Worked like a charm! Best present ever...
Thank you for the response...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks