I am trying to create a formula that looks at two variables on Sheet 1 and
returns a value from one of two columns on Sheet 3.

Essentially, what I'd like it to do is:

If B277 and B28<25, then return the value from sheet 3, C4 in C28 (first
sheet)
B28 is 25 to 29, then enter value from sheet 3, C5 in C28
B28 is 30 to 34, then enter value from sheet 3, C6 in C28
B28 is 35 to 39, then enter value from sheet 3, C7 in C28

etc. through B2865, then enter value from sheet 3, C13 in C28,
OR
If B27<7 and B28<25, then return the value from sheet 3, B4 in C28 (first
sheet)
B28 is 25 to 29, then enter value from sheet 3, B5 in C28
B28 is 30 to 34, then enter the value from sheet 3, B6 in
C28
B28 is 35 to 39, then enter the value from sheet 3, B7 in
C28
etc. through B2865, then enter value from sheet 3, B13 in C28

Is it possible to write one formula that looks at the first variable in B27
(< or 7 €“ this designates gender), then the number in B28 (age) and returns
a rate (values on sheet 3) bases upon those two?

Thanks!!