Lookup Prices Matching Code From 2 Tables

L

Legacy 436357

Guest
Hi,

Can someone derive formulas for I3:I8?

Thanks

Excel Workbook
BCDEFGHI
1Table 1Table 2Table 3
2CodePriceCodePriceCodePrice
3X1$ 2.00Y1$ 1.00X1
4X2$ 4.00Y2$ 3.00X2
5X3$ 6.00Y3$ 5.00X3
6Y1
7Y2
8Y3
Sheet1
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Hmm . . .

I can think of at least two possible solutions

1) Merge table 1 and table 2 into a single table.

2) In I3, something like this
Code:
=IFERROR(VLOOKUP(H3,B$3:C$5,2,FALSE),IFERROR(VLOOKUP(H3,E$3:F$5,2,FALSE),"No match found"))
 
Upvote 0
Mr. Higgins can this be adjusted please?


Excel Workbook
BCDEFGHIJKL
1Table 1Table 2Table 3
2CodeColumn2PriceCodeColumn2Column1PriceCodePrice
3X1$ 2.00Y1$ 1.00X10
4X2$ 4.00Y2$ 3.00X20
5X3$ 6.00Y3$ 5.00X30
6Y10
7Y20
8Y30
Sheet1
 
Upvote 0
Here's the adjusted version for Table 1, maybe you can figure out yourself how to adjust if for Table 2 . . .

In L3 . . .
Rich (BB code):
=IFERROR(VLOOKUP(K3,B$3:D$5,3,FALSE),IFERROR(VLOOKUP(K3,F$3:I$5,2,FALSE),"No match found"))
 
Upvote 0
Teach a man to fish thanks. I understand now what the number represents.

Thanks so much for your help!
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,114,002
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top