Nesting IF statement - pulling data from another worksheet

[CanaDaan]

Hi there,

I'm not that experienced with Excel, so I'm hoping this is an easy question for you!


I created the IF statement below and it returns the values "poor" and "good" - no issues there. For the third value, I want to pull text from another worksheet (Recommendations) which is in cell B5. But currently, Excel returns "=Recommendations'!B5". What am I doing wrong?

=IF($B3<5,"Poor",IF($B3>7,"=Recommendations'!B5","Good"))

Thanks!

 

[s hal]

=IF($B3<5,"Poor",IF($B3>7,Recommendations'!$B$5,"Good"))

Placing quotes around it places exactly what you typed in the cell. You will also want to lock your range so it doesn't move as you pull the formula down.

Hope this helps!

 

[CanaDaan]

Thank you so much! It definitely did the trick.