Jet Fusion
Member
Hi all
Is there a way to change this formula to show a blank cell until a value gets added to the adjacent cell.
=LOOKUP(2,1/(A1:B10<>""),A1)
Thank you
Is there a way to change this formula to show a blank cell until a value gets added to the adjacent cell.
=LOOKUP(2,1/(A1:B10<>""),A1)
Thank you