Hi all,
I am trying to retrieve data from column B (See table A) but the name list (See table B) that I got is different from the reference list.
The data below are all hypothetical:
Table A
Table B
I want to return the second column in Table A ($dollars) to the names in table B, but Vlookup does not work due to the names being written in a different order. Would appreciate any help, thanks!
I am trying to retrieve data from column B (See table A) but the name list (See table B) that I got is different from the reference list.
The data below are all hypothetical:
Table A
Jenny Elizabeth Mary | $10,000 |
James Tan Jun Kiat | $5,000 |
Mohammed Iskandar Bin Syahrul Ahmad | $15,000 |
Eileen Lim | $2,000 |
Jacky How Ling Ling | $1,000 |
Table B
Elizabeth Mary Jenny |
Tan Jun Kiat James |
Iskandar Bin Syahrul Ahmad |
Lim, Eileen |
How Ling Ling, Jacky |
I want to return the second column in Table A ($dollars) to the names in table B, but Vlookup does not work due to the names being written in a different order. Would appreciate any help, thanks!