In the attached spreadsheet, I have a table that consist of Type, Wt & Conv. I need to find the Conv value based on matching type (B1) and closest match to wt (B2). In my example, the formula would return in cell B4 the value 4.85082. This is because the type matches the value of 1 and the Wt is rounded up to a value of 780 (B16) therefore formula returned 4.85082 which is located in C16.
How would one do this?
Thanks in advance for the help.
-Manny
Bookmarks