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.

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" <ozcourtjester@discussions.microsoft.com> wrote in message
news:72E37409-E3DA-4C24-8FA8-DDF84EC67D32@microsoft.com...
> 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.