Hi All,
I'm looking for a solution in Join (lookup) for the below scenario.
I have a primary data which needs the code from the mapping sheet, while my primary has all column with data which is not the case with my mapping sheet.
I assure my first three column are unique and i required the "code" in primary comparing column to column with mapping chart ignoring the column with [Nul] in it.
| Mapping chart |
| 1st col | 2nd col | 3rd col | 4th col | 5th col | Code |
| A | B | C | [Null] | B | A |
| D | E | F | C | [Null] | B |
| G | H | I | [Null] | F | C |
| J | K | L | [Null] | [Null] | D |
| M | N | O | R | F | E |
| P | Q | R | G | [Null] | F |
| S | T | U | [Null] | F | G |
| V | W | X | [Null] | F | H |
| Y | Z | A | F | F | A |
| Primary Data | |
| 1st col | 2nd col | 3rd col | 4th col | 5th col |
| A | B | C | A | B |
| D | E | F | C | F |
| G | H | I | D | F |
| J | K | L | D | F |
| M | N | O | R | F |
| P | Q | R | G | F |
| S | T | U | D | F |
| V | W | X | F | F |
| Y | Z | A | F | F |
thanks
