Change your formula to

=IF(ISNA(VLOOKUP($B4,Inventory_List,8,0)),"",IF(VL OOKUP($B4,Inventory_List,8,0)<0,"INVALID SALE",VLOOKUP($B4,Inventory_List,8,0)))


"Rao Ratan Singh" wrote:

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))