OFFSET needs more parameters than that, or at least a place for them.

Try =OFFSET(A2,C1,) [with the extra comma.]
--
David Biddulph

"Luke M" wrote in message
...
There is a debate between which is better OFFSET/INDEX, but you could also
do:
=OFFSET(A2,C1)

Offset may give you more control if you want to control both row and
column
destination.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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?