LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 367
Default Look up Data by Row criteria and column criteria

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count how many criteria in a column match criteria in another colu Charles Stover Excel Discussion (Misc queries) 3 March 6th 09 08:39 PM
Sum data with criteria stored in row and column vivi Excel Worksheet Functions 3 October 16th 08 04:32 AM
Selecting data that matches certain criteria in one column Anthony Excel Discussion (Misc queries) 7 May 17th 07 12:48 PM
Help getting first column data based on criteria? Tami Excel Worksheet Functions 5 August 22nd 06 11:17 PM
How to add data to a column based on criteria from another Lynn Bales Excel Discussion (Misc queries) 4 July 14th 05 04:11 PM


All times are GMT +1. The time now is 09:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"