Hi
I m using this function =IF(VLOOKUP($B4,Inventory_List,8,0)<0,"INVALID
SALE",VLOOKUP($B4,Inventory_List,8,0)) but when B4 is blank it return #N/A. I
want this should return blank when b4 is blank.

How to change this function.=IF(VLOOKUP($B4,Inventory_List,8,0)<0,"IN VALID
SALE",VLOOKUP($B4,Inventory_List,8,0))