8 Nested "IF" statements (Or alternative?)

[muadebe]

I have a workbook that can handle pricing rates for 4 different cities. I need to expand it to 8 different cities.

I currently use a nested "IF" statement to determine the hourly rate for a process based on the selected city. I need to expand this to 8 possible cities and the correct hourly rate for each.

I've attached a sample excel sheet that simplifies what I am trying to do. Please take a look, hopefully someone can offer a solution. It doesn't need to be "IF" statements if something better is out there.

I would like to select city (1-8)

Have the correct hourly rate pulled into the cell from the data page based on the selected city (1-8)

If there is no hourly rate ($0.00) the cell should remain blank

Thank you for taking a look!

[Fluff13]

How about

Please Login or Register  to view this content.

[Bo_Ry]

Please try

=INDEX('Hourly Rates'!C8:U14,,MATCH("City "&'1'!E5,'Hourly Rates'!C7:U7,))