Forum Discussion
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...
Not sure which version of Excel you are using, I use office 2016 on my Mac and the IFS function is not supported (and returns NAME?), you will need to do nested IF statement to get it to work.
Richard
Richard
- Many thanks Richard, didn't see that stated anywhere, so will try Nested IF
- Just checked the Microsoft web site where they have the following note under the IFS description,
Note: This feature is available on Windows or Mac if you have Office 2019, or if you have an Office 365 subscription. If you are an Office 365 subscriber, make sure you have the latest version of Office.
Richard- 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))))
