another one,

try this in g2

=CHOOSE(C2,A3,A4,A5)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Aaargh" wrote:

I'm trying to set up a formula that will check the value of a cell, then
based on the value of that cell, will insert another value....i.e.

If C2 =1, then G2 = A3 or if C2 = 2, then G2 = A4, or if C2 = 3, then G2 = A5.

This will be across worksheets but all in the same workbook. The end
product will be a table where the user will input just a few variables and
Excel will populate the rest of the table.

Can this be done?