In the absence of a Power Query solution, or any other proposal, let's go "old school":
Use a Helper Column, say Column M. Then . . .
Cell: M2
=IFNA(VLOOKUP(G2,P:R,3,FALSE),G2)
and copy down to end of data
Then copy the entire column M.
Paste Special | Values over column G
Delete column M
(and any unrequired data)
Save as .csv file (recommend saving with a new file name)
Upload .csv file
You could, if you wish, record a macro while you go through the steps manually. However, it will need tweaking and it may not be worth the effort.
Bookmarks