Hello Everybody!
I am working on a spreadsheet in which I must locate the next higher value in an unsorted table. No, I can't re-sort the table.
I can't use VLOOKUP or HLOOKUP because the LOOKUP function only finds the next lower value.
I have been attempting to use an INDEX-MATCH formula, but I am running into trouble, as I need an approximate match, and I cannot use the "-1" data_type with an unsorted table.
To clarify with values, a cell contains the value 0.58.
I have a table that looks like the following:
Load: .60 .61 .62
Pmax 34 45 64
I want to find the approximate Pmax value for the percent .58. Thus, I want a function that will give me the Pmax value for .60, as it is the next highest percent. In this case, the value I am looking for is 34.
I wish I could post a workbook, but this is confidential work material.
Any help is GREATLY appreciated!
Bookmarks