Forum Discussion

1orlando's avatar
1orlando
Copper Contributor
Dec 17, 2019

IFS function with sheet link

Hi all In an IFS function I want to have the return values from a different worksheet - but don't know whether this is not possible (no examples show this) or there is a simple novices error in my c...
Excel on Mac
1orlando's avatar
1orlando
Copper Contributor
Dec 17, 2019
Thanks I am using my work Office 365 which is 2016, so that's that. My first attempted nested IF doesn't work either
=IF(G3=“Male Hip”,Sheet3!$R$28,IF(G3=“Male Any”,Sheet3!$P$28,IF(G3=“Female Hip”,Sheet3!$Q$28,IF(G3=“Female Any”,Sheet3!$O$28))))
Rich99's avatar
Rich99
Iron Contributor
Dec 17, 2019

Hi 1orlando 

 

I too had the same problem with your IF statement, ended up redoing it (but looks the same), have attached what I did for your info. I expect someone smarter than us will have an answer.

 

Richard

  • 1orlando's avatar
    1orlando
    Copper Contributor
    Dec 17, 2019
    Again many thanks richard. It won't be difficult to find someone smarter than me!

Resources