IF Statements

[HandyAndy]

Hi Everyone
I have a question about IF statements.
On Sheet 1, l have a cell called E5 which has a drop down menu with the following selections:
- Option 1
- Option 2
- Option 3

Depending upon which option is selected, it will pull a cell value from 3 different sheets, lets call that value cell A1.
So if Option 1 is selected, in another cell l need to pull cell A1 from 'Option 1 Sheet'
If Option 2 is selected, it pulls cell A1 from 'Option 2 Sheet'
And if Option 3 is selected, it pulls cell A1 from 'Option 3 sheet'.

=IF('Sheet1'!$E$5="Option 1",'Option 1 Sheet'!A1, IF ('Sheet1'!$E$5="Option 2",'Option 2 Sheet'!A1, 'Sheet1'!$E$5="Option 3",'Option 3 Sheet'!A1
and l get stuck.
Would appreciate help of the group please.
Thanks in advance!!!
HandyAndy

 

[johnnyL]

What are you doing with the A1 cell value once you 'pull' it?

 

[HandyAndy]

In its simplest form, i have a summary sheet that shows the value of A1 for Option 1, or Option 2, Option 3. I am just referencing the value.

 

[johnnyL]

Ohhhh, you want a cell formula, not a macro, I missed that part when I first read the question

=IF(Sheet1!E5="Option 1",'Option 1 Sheet'!A1,IF(Sheet1!E5="Option 2",'Option 2 Sheet'!A1,IF(Sheet1!E5="Option 3",'Option 3 Sheet'!A1,"")))

 

[johnnyL]

Or a slight mod which will automatically use the value from 'Option 3 Sheet' if 'Option 1' or 'Option 2' is not found...

=IF(Sheet1!E5="Option 1",'Option 1 Sheet'!A1,IF(Sheet1!E5="Option 2",'Option 2 Sheet'!A1,'Option 3 Sheet'!A1))

 

[HandyAndy]

The slight mod worked the best - thank you so much. Good karma to you johnnyL

 

[johnnyL]

Thank you @HandyAndy

You could switch the order in the formula if you would prefer one of the other Option sheets to be the default value displayed.