Macro for if cell A2 has text then cell B2 must have numeric value.

[Admin]

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.

[Carlos Arruda]

vlookup formula is not in B2, only in other fields such as units and prices and vat.

B column is purely quantity and it can be 1 or 5.