Forum Discussion
IFS condition in another iFS
Hi, im kind of struggling writting an IFS into an IFS. I would like to calculte the number of sets, depending on : - if the cell C14 is equal to 0, 1 or 2 (0 for squat, 1 for bench, 2 for deadlif...
I think the IFS formula is going in cell F14 and based on the value of D14 it should look up the corresponding value in Settings!$D$17:$D$19. My first point is that D14 should be TEXT to match the TEXT in Settings!$C$17:$C$19 and then use XLOOKUP
=XLOOKUP(D14,Settings!$C$17:$C$19,Settings!$D$17:$D$19,"incorrect selection",0)
=XLOOKUP(D14,Settings!$C$17:$C$19,Settings!$D$17:$D$19,"incorrect selection",0)
Hi, thanks for your reply.
I played with XLOOKUP, but i always end up with #error
I played with XLOOKUP, but i always end up with #error