software

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, quot;Wolfquot; 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 quot;namequot; of those coordinates.
Any ideas or suggestions? I am out of ideas at this point.
Appreciate the help.

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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;ozcourtjesterquot; gt; wrote in message
...
gt; I am trying to build a grid based off XY coordinates in a spreadsheet format
gt; and trying to prevent entering the data in manually. Basically I have a
gt; spreadsheet with names and the respective XY coordinate.
gt; Ex:
gt; A B C
gt; Name X Y
gt; 1|Wolf 22 6
gt; 2|Bear 12 2
gt; 3|Eagle 16 3
gt;
gt; In another worksheet, I have a grid and I would like to reference the
gt; spreadsheet so that at junction X22:Y6 in the grid worksheet, quot;Wolfquot; is
gt; populated.
gt; I think I can get to the point of using an array formula so that it looks up
gt; the X and Y values in columns B and C, but reaching a roadblock when it comes
gt; to outputting the respective quot;namequot; of those coordinates.
gt; Any ideas or suggestions? I am out of ideas at this point.
gt; Appreciate the help.