relate two worksheets automatically - question!

Hello,

A Vlookup will help you with this.

I created a dynamic range so you will never have to worry about how many rows of data you need.

Formula:

Cod_2=OFFSET(Sheet2!$A$1,0,0,COUNTA(Sheet2!$A:$A),2)

And then you use the VLOOKUP formula in Sheet 3

Formula:

=IFERROR(VLOOKUP(A2,cod_2,2,FALSE),"No Data")

I have attached a sample workbook to make it more clear.
Attachment 263826

many thanks! it solved my problem!