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
Bookmarks