In column C, I'd like to pull the cost from G3:I5 based on the criteria in columns A and B (Gauge and Width). For instance, C2 would pull the number from I3=$0
In column C, I'd like to pull the cost from G3:I5 based on the criteria in columns A and B (Gauge and Width). For instance, C2 would pull the number from I3=$0
I moved the table E1:I5 down one row to make room for the width range headers. (See below.)
Then in C2 and filled downFormula:Please Login or Register to view this content.
A B C D E F G H I J 1 Gauge Width Cost $ Width 2 0.1210 50 $ - Min Gauge 36 42 48 3 0.0900 46 $ 1.50 Under Thru 42 48 72 4 0.1050 38 $ 3.00 0.6250 0.0810 $ 3.00 $ 1.50 $ - 5 0.1210 46 $ 1.50 0.0810 0.0660 $ 3.50 $ 2.00 $ 0.50 6 0.0900 70 $ - 0.0660 0.0560 $ 5.50 $ 4.00 $ 2.50 7 0.1050 46 $ 1.50
Dave
Hello osugirl7 ,
In case you don't want to change set up then copy paste below in C2 and drag down
Formula:Please Login or Register to view this content.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Thank you Dave that worked!
Thank you hemesh that worked too!
Thanks for the feedback and REP Osugirl7
Same here osugirl, and thank you for marking your thread Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks