Vlookup in another workbook and replace data

[excel01noob]

I need to combine the customer ID from one report received (table 1) with a table where I need to find the respective Account reference (table 2).
Issues I have:

-Customer ID is formatted as "number" in table 1. If that ID is => to 6 characters I need to take the first 3 digits from the customer ID (from the left);

Table 1

id	sales	Customer ID
chair	1000​	1008000​
table	1000​	1045070​
wardrobe	15000​	12345​
chair	34000​	123​
table	43000​	654321​
wardrobe	12000​	1051​
chair	450003​	7071​

-with those 3 digits, I need to search in the customer ID on table 2 (which is not formatted as number but as text). When that is matched, I need to take the Acc ref

-then paste it in another sheet Column G (I add this sheet named "Final data" in the same file from where I am getting the table 1 raw data.

Table 2

Customer ID	country	Acc ref
108	PRT	PT10081990
145	LUX	X10082004
294	ESP	S10082017
389	FRA	F10082017
589	GER	G10092016
988	UK	UK10091975
230	SLO	SO10092000

How to set up this?

 

[GraH]

Vlookup(left(customer id, 3), table2, 3).

But then with correct references.

 

[excel01noob]

it works

but in VBA how would it be?

 

[GraH]

Hi, for VBA I do not know.
For future posts you might consider using tags like #VBA so we know you ask for a VBA solution.
Try recording the macro and see if the code is adaptable for you.