Hi,
Can anybody help me with this one please?
I am using the formula below in a sheet to avoid duplicating entries if they match earlier rows and it's working well but I need to extend beyond 8 nested IFs
Below is the next formula I'd like to be able to write.....but too many IFs
Is there a way to achieve the above?
Any help is much appreciated.
thank you,
Iain
Can anybody help me with this one please?
I am using the formula below in a sheet to avoid duplicating entries if they match earlier rows and it's working well but I need to extend beyond 8 nested IFs
Excel Formula:
=IF($G19=" ","",IF($G19="","",IF($G19=$G18,"see above",IF($G19=$G17,"see above",IF($G19=$G16,"see above",IF($G19=$G15,"see above",IF($G19=G14,"see above",IF(G19=$G13,"see above",IF(G19=$G12,"see above",VLOOKUP($G19,$S$57:$U$68,2,0))))))))))
Below is the next formula I'd like to be able to write.....but too many IFs
Excel Formula:
=IF($G19=" ","",IF($G19="","",IF($G19=$G18,"see above",IF($G19=$G17,"see above",IF($G19=$G16,"see above",IF($G19=$G15,"see above",IF($G19=G14,"see above",IF($G19=$G13,"see above",IF($G19=$G12,"see above",IF($G19=$G11,"see above", VLOOKUP($G19,$S$57:$U$68,2,0)))))))))))
Is there a way to achieve the above?
Any help is much appreciated.
thank you,
Iain