Dec 17 2019 04:35 AM
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 current attempt (which returns NAME?)
=IFS(G3=“Male Hip”,Sheet3!$R$28,G3=“Male Any”,Sheet3!$P$28,G3=“Female Hip”,Sheet3!$Q$28,G3=“Female Any”,Sheet3!$O$28)
Thanks for help...
Dec 17 2019 05:18 AM
Dec 17 2019 05:24 AM
Dec 17 2019 05:29 AM
Dec 17 2019 05:34 AM
Dec 17 2019 05:59 AM
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
Dec 17 2019 06:13 AM
Dec 17 2019 06:21 AM
Dec 17 2019 07:15 AM
Dec 17 2019 07:16 AM
Dec 17 2019 12:57 PM
As a comment, IFS() shall work on Mac same way as on Windows, i.e. only for Office 365 subscribers or on Excel 2019 for Mac.
#NAME! error could be not only since function doesn't exist, but as well if within formula appears curly quote character ” instead of straight quote ".
Dec 17 2019 01:10 PM
Dec 17 2019 01:21 PM
Yes, they have different meaning and quite often straight quote is converted into curly one if copy/paste formula from the web. Just be careful with this.