Return variable value based on drop-down

Hello everyone. First off I would like to thank you in advance for your help. Second of all the project I am working on contains sensitive information so I cannot be exact with some of the things I am describing.

So here is what I am trying to do.
I need cell F5 on the sheet "Extra Work" to automatically be filled with the price of a particular service that is named by a drop down box on the same sheet in cell D5. Since the price varies by location the formula needs to only fill in the price of the service according to what the user enters as his region. The user will select his region name in cell G2 from a drop down box on the sheet "inputs". The table of prices for each region is on the sheet "pricing". The names of the regions are on the "pricing" sheet from cells A3 to A21. The names of the services are in cells B2 to AF2 on the same sheet. Something like this:

--------------Service 1--Service 2--Service 3--Service 4
Region A------$10-------$22--------$34-------$14
Region B------$9--------$21--------$33-------$13
Region C------$13-------$25--------$36-------$16
Region D------$11-------$23--------$36-------$15

So basically I need a formula that enters a price automatically depending on the service and the region it was performed in. Unfortunately I am in over my head here . Thanks again for your help.

We would love to help you with your query, but first, before we can proceed, please see our Forum Rules #1 about proper thread titles and adjust accordingly...

• To change a Title on your post, click EDIT then Go Advanced.
• If 2 days have passed, ask a moderator to do it for you.

Assumning your data is in A1:E5, including headings and row names, and you have the Servive drop-down in G1 and the Region dropdown in H1, use this...

=INDEX($A$1:$E$5,MATCH($H$1,$A$1:$A$5,0),MATCH($G$1,$A$1:$E$1,0))

Well first thing I see, the ranges overlap each other. This could be causing a problem, but overall, the formula FD provided seems the right way to go...

I understand your file contains sensitive information, but could you not put together a sample test file.

Based on the requirements from post #1, maybe...

=INDEX($B$3:$AJ$22,MATCH(Inputs!$G$2,$A$3:$A$22,0),MATCH('Extra work'!$D$5,$B$2:$AJ$2,0))

Thanks jeff.

@ MrNewb, its hard to develop anything when all you have to go on are a few lines of info copied here I may have some of theranges a little off, so try adjusting them a bit?