It would work beautifully if on the "other worksheet" you add both row labels
and column headers on the table. That way you can easily use a MATCH and
INDEX formula in column C to give you the number you want. Quick example of
the layout of that table, and while I've put the jewels across as column
headers, it doesn't have to be that way, we'd just change the formula in
column C. But as an example

A B C D E F
1 China USA ...
2 Agate 1394 1222
3 Pearl 999 444
4 ...
5 ...
6 Topaz
hopefully that gives you an idea of the layout of that table. Let's also
say the name of that worksheet is 'TableSheet'.

Now on your sheet where you are choosing gems and countries, let us presume
you have a choice made in A2 (gem) and B2 (country) and you put this formula
in C2
=INDEX(TableSheet!$A$1:$F$6,MATCH(A2,TableSheet!$A $1:$A$6,0),MATCH(B2,TableSheet!$A$1:$F$1,0))

and it would work great for you.

"Marilyn" wrote:

I'm using Excel 2003.

Sorry, I'm if not explaining this well. I'm trying to put information in a
column that comes from another worksheet in the same book but it depends on
what is entered in 2 other columns in the first worksheet. I'll try to give
complete info:

Let's say Column A asks you to pick 1 of 5 gems: Agate, Turquoise, Garnet,
Diamond, Pearl
Let's say Column B asks you to pick 1 of 6 Countries: US, Can, UK, China,
Japan, Germany

The other worksheet has a table with data (its a number in each cell)
representing all the possible permutations of those choices. However (and
this might present a problem) the row/column headers of this table are not
gems and countries. Its just a stand-alone table. Is that a problem?

So, on Column C, is there a formula to recognize which gem you picked in
Column A, which country you picked in Column B then go to the table and bring
in the
number from a table and put it into Column C. (Eg if I picked Agate and
China, I want Column C to say 1394).

Thanks!