Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
looking up data in a table using 2 criteria
I am looking for help on the following problem.
In Column A I have values from 65 to 99 (random) representing a percentage. In column B I have ratings from A to E. Also I have a table with (max) relative positions in the columns(65, 70, 75, 80, 85, 90, 95, 100) and a percentage depending on these ratings on rows, so this is a matrix of 8 columns by 5 rows. The actual relative position is shown in cell A3, the rating in cell B3. Now I want to compare the value in A3 with the max. relative position in the table, lookup the value that corresponds with the rating in B3, and place it in cell C3 and so on. I have tried combining HLOOKUP and VLOOKUP, but that seems to be the wrong solution. Does anybody here have another bright idea? I can't include a copy of the sheet, but I hope the description helps. Looking forward to your solutions. Willem. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
summing values in a data table based on criteria in another column | Excel Worksheet Functions | |||
extract data from table that meets set criteria | Excel Discussion (Misc queries) | |||
how to i pivot a table using various criteria | Excel Worksheet Functions | |||
criteria for Pivot Table | Excel Discussion (Misc queries) | |||
How do I look up a value in a table with 2 criteria? | Excel Worksheet Functions |