Hi all,

I am looking to use the VLOOKUP function to caputure the contents of the
first nonblank cell. At the moment, I am capturing the first match - which
may be blank or non blank.

How do I capture non-blank cells only?

Thank you.

Clarissa.