Hello
I want the 'data' spreadsheet to populate the lat and long from the 'location' sheet by a forms of a v lookup
Hello
I want the 'data' spreadsheet to populate the lat and long from the 'location' sheet by a forms of a v lookup
Try this:
B2 =INDEX(LOCATION!D:D,MATCH($A2,LOCATION!$A:$A,0))
Drag the formula to the right and then down.
Note that you have some cells that have a white font.
Hello,
that brings back blank results
Hello
Apologies.. I think I have got it working
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks