Ask Your Question
0

Get field by matching ID from another sheet

asked 2018-01-06 16:13:14 +0200

rosiraab gravatar image

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.

Screenshot

I've uploaded my document here: XUP.IN

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-01-06 17:01:15 +0200

Lupp gravatar image
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-01-06 16:13:14 +0200

Seen: 177 times

Last updated: Jan 06 '18