How to use multiple lookups or if statements

A

Andrea

I have spreadsheet 1 where states are broken out into zones:
AL Zone 1
CA Zone 2
SD Zone 3

Then another table that states prices for each zone:
.14-.16 .17-.19
Zone1 .006 .028
zone2 .005 .015
zone3 .003 .005

So, if I'm working in spreadsheet 2 and enter an index price value of .15 in
cell a1, what formula could I use to look up the states in column d
(spreadsheet 2) and pull the price (.006 etc depending on zone) for the .15
value of the month?

I appreciate any help that is given!
 
Top