Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing XY Grid Coordinates
I am trying to build a grid based off XY coordinates in a spreadsheet format
and trying to prevent entering the data in manually. Basically I have a spreadsheet with names and the respective XY coordinate. Ex: A B C Name X Y 1|Wolf 22 6 2|Bear 12 2 3|Eagle 16 3 In another worksheet, I have a grid and I would like to reference the spreadsheet so that at junction X22:Y6 in the grid worksheet, "Wolf" is populated. I think I can get to the point of using an array formula so that it looks up the X and Y values in columns B and C, but reaching a roadblock when it comes to outputting the respective "name" of those coordinates. Any ideas or suggestions? I am out of ideas at this point. Appreciate the help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing XY Grid Coordinates
You can't push a value to another cell.
You need to write a macro to use CELLS function in a macro with Column C as the row offset, and column B as the column offset. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "ozcourtjester" wrote in message ... I am trying to build a grid based off XY coordinates in a spreadsheet format and trying to prevent entering the data in manually. Basically I have a spreadsheet with names and the respective XY coordinate. Ex: A B C Name X Y 1|Wolf 22 6 2|Bear 12 2 3|Eagle 16 3 In another worksheet, I have a grid and I would like to reference the spreadsheet so that at junction X22:Y6 in the grid worksheet, "Wolf" is populated. I think I can get to the point of using an array formula so that it looks up the X and Y values in columns B and C, but reaching a roadblock when it comes to outputting the respective "name" of those coordinates. Any ideas or suggestions? I am out of ideas at this point. Appreciate the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Partial Grid Lines | Excel Discussion (Misc queries) | |||
printing grid lines | Excel Discussion (Misc queries) | |||
Radar Plot using geographical coordinates | Charts and Charting in Excel | |||
grid & grid refrences | New Users to Excel | |||
Bold Grid Lines | Excel Discussion (Misc queries) |