Pull out col. header from table based on two input parameters to search for in the table.

Hi Guys,

I had the help of a few forum members for the solution to a problem in an earlier post, see link below for the original post. I now need to revise the problem and place the two input parameters and the cell of my desired result on a different worksheet from that of the table its referencing. I have attached the example workbook as described below.

The problem
I need to find the next greatest value for input parameter 1 (cell C2 Sheet 2) in the table on Sheet 1 in the first column, (column B sheet 1). The values in column B ascend in 1/2 increments, so I would need to find the next greatest half increment value. Once the next greatest value is found in the column I need to go into it's associated row of the table and find the next greatest value for parameter 2 (Cell D4, Sheet 2) and output the header of that column with the associated next highest value above parameter 2. For the input values already shown in my example, the result in Cell D6 of sheet 2 should display 6x8.

In the link below you will see JeteMC's solution which works for when the input parameters and the table were on the same worksheet, but since I need them on different sheets I cannot modify it to do so.

http://www.excelforum.com/excel-form...ng-values.html


Hope this is all clear and thanks for taking the time to look and help out!

Try pasting this formula into Sheet2!D5:

Please Login or Register  to view this content.

Let me know if you have any questions.

Another cracked case. Thanks!

You're Welcome and Thanks for the feedback. Hope that you have a good day.