question.PNG
Lookup in column B, if value is #N/A then print last numeric value.
As shown in example
question.PNG
Lookup in column B, if value is #N/A then print last numeric value.
As shown in example
=lookup(99^99,b4:b10000)
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks