ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   looking up data in a table using 2 criteria (https://www.excelbanter.com/excel-worksheet-functions/158909-looking-up-data-table-using-2-criteria.html)

Willem

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.




All times are GMT +1. The time now is 01:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com