excel01noob
Board Regular
- Joined
- Aug 5, 2019
- Messages
- 93
- Office Version
- 365
- 2016
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
-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
How to set up this?
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?