Match two cells and bring back the results from a third

I used to do this a long time ago and I thought I used an Index formula, I'm positive I did, but I can't get it to work.

Here's what I'm trying to do: Using two different spreadsheets, I need to bring back unit prices unique to specific hospital locations that use the same part numbers, however each hospital pays a different amount.

My current spreadsheet is only allowing for ONE hospital since they are all under a parent umbrella, but I need to distinguish pricing because of such a large disparity. Part #123 has three different prices, but in my current spreadsheet it's only allowing for one price. I need to show each price at each location.

I need to tell my current spreadsheet to match the Part # to the Location on the second spreadsheet and bring me back the results unique to that combination. How do I do that?

SPREADSHEET A

COLUMN A COLUMN B
PART # PRICE
ROW #1 123 $1.00
ROW #2 456 $7.00



SPREADSHEET B

COLUMN A COLUMN B COLUMN C
PART # LOCATION PRICE
ROW #1 123 HOSP A $1.00
ROW #2 123 HOSP B $2.00
ROW #3 123 HOSP C $3.00
ROW #4 456 HOSP A $7.00
ROW #5 456 HOSP B $8.00
ROW #6 456 HOSP C $9.00

Yes, I've added in new cells in the 2nd spreadsheet to accommodate the different locations.