Good Morning Everyone!
I've got a formula that almost works - I can get the right value, but I want to get the value of the cell that's in the same row, but in a different column. I've tried everything I can think of, but my formula isn't getting the row number but the value, so OFFSET doesn't work.
My overall goal is to find the right piece of equipment depending on the tonnage (AB1), refrigerant type (AC7:AL7) and the temperature (AC8:AL8). I've got it to where it'll look down the column for the first value that's equal to or greater than the value of AB1, but I can't get it to return the value of the cell that's in in Col AB. For example, if the ton value is 104 (AB1), the refrigerant is R-22, and the temp is 40, then the correct part would be in Cell AB12 (S-7727KW).
Any gurus know of a way to return the offset cell of the returned value? I'll figure out how to add in the conditionals of the refrigerant/temp/tonnage later, but I want to get this out of the way.
Thanks for any direction you can give
Excel_Formula_Example-01.jpg
Bookmarks