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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multiple ranking (sorting), based on diff. criteria 0
Looping Macro to scrap multiple pages in Mainframe 2
Formula to look up values 3
Exporting Access to Excel on Multiple Named extra sheets created 1

Top