i have heard about index, match and vlookups,... but dont know how to use them,
i have attached my workbook. my problem is; i play a game on facebook and they have introduced something called relay towers. now these relay towers are teleporters to different sectors. the problem is... if you find a target to hit in another sector i want to write that target down on my spreadsheet so itll tell me the nearest relay tower to it. the game itself does this if you are already there so you can find your nearest tower for the return trip. but if youre not there then i need to see where the nearest is so i can get there.
Bookmarks