Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need a formula
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? |