Look for data in other sheets and display data in corresponding rows

[goble]

Hello,

I have sheet 1 and sheet 2 which contain data. I have sheet 3 on which I want to report Data for some (not all) rows in sheet 1 and sheet 2. So that when I insert the refs in column A, the data appear in columns 2 and 3.

Thanks !


sheet1

IN0001	Apple	Red
IN0002	Pear	Green

sheet2

SN0001	Cat	White
SN0002	Dog	Black

sheet3 (results)

IN0002	Pear	Green
SN0002	Dog	Black
IN0001	Apple	Red

 

[alansidman]

Book2
	A	B	C
1	IN0002	Pear	Green
2	SN0002	Dog	Black
3	IN0001	Apple	Red
Sheet3

Cell Formulas
Range	Formula
B1:B3	B1	=IFERROR(VLOOKUP($A1,Sheet1!$A$1:$C$2,2,FALSE),VLOOKUP(Sheet3!$A1,Sheet2!$A$1:$C$2,2,FALSE))
C1:C3	C1	=IFERROR(VLOOKUP($A1,Sheet1!$A$1:$C$2,3,FALSE),VLOOKUP(Sheet3!$A1,Sheet2!$A$1:$C$2,3,FALSE))