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.

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.