I would like to get field contents (latitude & longitude) from sheet 2 into sheet 1 by matching their IDs. My dataset is the Form EIA-860 Data about power plants in the US.
Probably I should do this with a MATCH function, but couldn’t figure out how.
I’ve uploaded my document here: XUP.IN