LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KD KD is offline
external usenet poster
 
Posts: 41
Default lookup functions

I need to return a value at the intersection of a row and column when the
value in a ro and a seperate value in a column is met. I can't find a way to
do this when the values are based on a variable in a certain cell. For
example:

If the dwelling value is 30,999 and is in protection class 5 then I need to
return the value at the intersection of these two variables (the answer is
461) but how do I write that formula. The dwelling value and protection class
would come from the same cell's each time but the values in those cells would
be different.

Protection Class
DWELLING VALUES 1 2 3 4 5
25,000-25,999 405 405 405 405 405
26000-26999 417 417 417 417 417
27000-27999 430 430 430 430 430
28000-28999 443 443 443 443 443
29000-29999 452 452 452 452 452
30000-30999 461 461 461 461 461
31000-31999 470 470 470 470 470
32000-32999 479 479 479 479 479
33000-33999 486 486 486 486 486
34000-34999 493 493 493 493 493
35000-35999 500 500 500 500 500
36000-36999 508 508 508 508 508
37000-37999 514 514 514 514 514
38000-38999 520 520 520 520 520
39000-39999 526 526 526 526 526
40000-40999 532 532 532 532 532
41000-41999 538 538 538 538 538
42000-42999 544 544 544 544 544
43000-43999 551 551 551 551 551
44000-44999 558 558 558 558 558
45000-45999 565 565 565 565 565
46000-46999 572 572 572 572 572
47000-47999 579 579 579 579 579
48000-48999 586 586 586 586 586

 
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
lookup functions Srinivas Excel Discussion (Misc queries) 5 April 1st 08 02:59 PM
help on lookup functions Kesqsay Excel Worksheet Functions 1 November 17th 05 04:23 PM
Lookup Functions nick Excel Worksheet Functions 3 October 11th 05 04:02 PM
LOOKUP functions? MIKDU Excel Worksheet Functions 4 April 28th 05 02:40 AM
Lookup Functions Sharon Excel Worksheet Functions 6 February 20th 05 05:04 AM


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

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"