Forum Discussion

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

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

Iron Contributor

Dec 17, 2019

Just been playing around with your IF statement, Appears that if you retype all of the G3="..." references then the formula works. For some reason it just didn't like that part of the formula.

Richard

1orlando
Copper Contributor
Dec 17, 2019
for the record
=IF(G3="Male Hip",Sheet3!$R$28,IF(G3="Male Any",Sheet3!P28,IF(G3="Female Hip",Sheet3!$Q$28,IF(G3="Female Any",Sheet3!O28))))
1orlando
Copper Contributor
Dec 17, 2019
Yes tried that and then accepted a suggestion though i couldn't see the difference to what i had ! and it works! many thanks for your effort.