how can I select two different values for a cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a sheet with one column I would like to give it two values. In fact I
would like the column show me the ACTUAL value or the FORECAST value anytime
I want .I don't like to make 2 columns and fill one column with actual data
and the other with forecast data.How can I do that?
 
Hi,

Have you considered using Comment as storage for the second value?

Another way might be introducing the following formula into the cell and
changing the A1 depending onthe value you want to see:

=INDEX({Value1,Value2},$A$1)

Regards,
KL
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum of data ranges in two different sheets giving two conditions 2
Copying worksheet A values into worksheet B - missing cell values 16
Code copies ONLY last j from sheet 9
A data validation question 1
Can you improve the performance on my user defined function? 2
Transfer array element offset value to a matched value 3
slow code with many loopings 6
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2

Back
Top