K
KD
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
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