need a formula
In Cell G2 type =IF(C2=1,A3,IF(C2=2,A4,IF(C2=3,A5,IF(C2=4,A6,""))) )
This should give you the values you've entered in A3, A4, A5 etc in cell G2
depending what value is in C2,
Best regards,
Gareth
"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?
|