Lookup Prices Matching Code From 2 Tables

[Legacy 436357]

Hi,

Can someone derive formulas for I3:I8?

Thanks

Excel Workbook
	B	C	D	E	F	G	H	I
1	Table 1			Table 2			Table 3
2	Code	Price		Code	Price		Code	Price
3	X1	$ 2.00		Y1	$ 1.00		X1
4	X2	$ 4.00		Y2	$ 3.00		X2
5	X3	$ 6.00		Y3	$ 5.00		X3
6							Y1
7							Y2
8							Y3
Sheet1

 

[Gerald Higgins]

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

=IFERROR(VLOOKUP(H3,B$3:C$5,2,FALSE),IFERROR(VLOOKUP(H3,E$3:F$5,2,FALSE),"No match found"))

 

[Legacy 436357]

Thank you Gerald Higgins that works great!

 

[Legacy 436357]

Mr. Higgins can this be adjusted please?

Excel Workbook
	B	C	D	E	F	G	H	I	J	K	L
1	Table 1				Table 2					Table 3
2	Code	Column2	Price		Code	Column2	Column1	Price		Code	Price
3	X1		$ 2.00		Y1			$ 1.00		X1	0
4	X2		$ 4.00		Y2			$ 3.00		X2	0
5	X3		$ 6.00		Y3			$ 5.00		X3	0
6										Y1	0
7										Y2	0
8										Y3	0
Sheet1

 

[Gerald Higgins]

Here's the adjusted version for Table 1, maybe you can figure out yourself how to adjust if for Table 2 . . .

In L3 . . .

=IFERROR(VLOOKUP(K3,B$3:D$5,3,FALSE),IFERROR(VLOOKUP(K3,F$3:I$5,2,FALSE),"No match found"))

 

[Legacy 436357]

Teach a man to fish thanks. I understand now what the number represents.

Thanks so much for your help!