Compare data in 2 sheets

[Poppy12]

Hello

I have 2 Sheets

Sheet 1 Column A, contains values I wish to search for matches in Sheet 2 Column A
If a match is found I wish to pull in data from Columns B,C & D from Sheet 2 into Sheet 1 for the corresponding match in Column A
For any data in Sheet 1 Column A that doesn't have a match in Sheet 2, I want to see an 'ERROR' message or similar

I'm not an Excel expert so is there a reason the attached file isn't working? Is it due to cells with no data on Sheet 2?

Thankyou

 

[ETAF]

using a =COUNTIF(Sheet2!A:A,Sheet1!A2)
I dont see any examples where it matches

 

[Poppy12]

Apologies, I didn't include all the data
I've added some additional data but the formula doesn't seem to be working

 

[ETAF]

i would use an index match
not sure what you have now - as data is all over the sheets
based on

Sheet 1 Column A, contains values I wish to search for matches in Sheet 2 Column A
If a match is found I wish to pull in data from Columns B,C & D from Sheet 2 into Sheet 1 for the corresponding match in Column A

this will return the contents of column B
=INDEX(Sheet2!$B:$B,MATCH(Sheet1!A2,Sheet2!$A:$A,0))
where there is a match
to get an error message when NO match then
=IFERROR(INDEX(Sheet2!$B:$B,MATCH(Sheet1!A2,Sheet2!$A:$A,0)), "Error")
as i have used in column AO

to get C and D
=INDEX(Sheet2!$C:$C,MATCH(Sheet1!A2,Sheet2!$A:$A,0))
=INDEX(Sheet2!$D:$D,MATCH(Sheet1!A2,Sheet2!$A:$A,0))

then wrap in an IFERROR ()
=IFERROR(INDEX(Sheet2!$B:$B,MATCH(Sheet1!A2,Sheet2!$A:$A,0)), "Error")

i have just added the first formula in cell AO , as i did not know where you wanted the results to be put as you have data in a lot of columns

 

[Poppy12]

Thats great, thankyou

 

[ETAF]

you are welcome