Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to build a formula that looks up an identifyer in a row and a
column, such as the following: 0 1 2 3 4 $250 0.01% 12.50% 12.50% 20.00% 20.00% $12,500 0.01% 8.33% 8.33% 8.33% 13.33% $37,500 0.01% 6.25% 6.25% 6.25% 6.25% $125,000 0.01% 5.00% 5.00% 5.00% 5.00% $187,500 0.01% 4.17% 4.17% 4.17% 4.17% $250,000 0.01% 3.57% 3.57% 3.57% 3.57% I want my formula to see that the dollar amount is 37,500 and it fits under number 3 so the result should be 6.25%. Keep in mind I am pulling the 37500 from one cell and the number 3 from another cell. I want this in one formula and if the result is NA it will read zero instead. Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count how many criteria in a column match criteria in another colu | Excel Discussion (Misc queries) | |||
Sum data with criteria stored in row and column | Excel Worksheet Functions | |||
Selecting data that matches certain criteria in one column | Excel Discussion (Misc queries) | |||
Help getting first column data based on criteria? | Excel Worksheet Functions | |||
How to add data to a column based on criteria from another | Excel Discussion (Misc queries) |