formula to insert code and description automatically from another database based on ref

[JEAN1972]

Hi All
I looking for a formula to insert data in header field REF and description of goods _1 header IN SAMPLE SHEET automatically based on REF header of sample database sheet where H code header and DESCRIPTION header data are found.

Annexed sample what i am expecting

For moment i use autofilter and find but very tedious .

Can anyone help.

Thanks in advance

[davesexcel]

It would have to be an array formula, and I hate those.
So I wrote a sub.
just click the button.
This is a macro enabled workbook, so you will have to enable macros when you open it.

this is the code anyway, just a double loop.

Please Login or Register  to view this content.

The other column s in the sample workbook is just a formula to count how many matches there really where.
You will see there are only 18 matches.

[plan]

Use iferror + vlookup formula in sample sheet

Hcode column (a2) formula - =IFERROR(VLOOKUP(C2,'Sample Data base '!$A$1:$D$1189,3,0),"")
Description of Good column (b2) formula - =IFERROR(VLOOKUP(C2,'Sample Data base '!$A$1:$D$1189,4,0),"")

Attached spreadsheet too...

[JEAN1972]

Hi Plan

I tried to drag formula but obtain #name

See attached could you help me

Thanks