Hi Albert,

Welcome to ExcelFox!!

What you are asking can be achievable by tweaking the b2 formula.

in b2

=if(len(a2),iferror(yourvlookupformula,"Not found"),"")

it checks a2 and if a2 has value in it, performs vlookup and if it doesn't find a value to return, gives "not found" otherwise returns the found value. Now if a2 remains blank, b2 will also remain blank.