Returning #N/A
 

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

Returning #N/A
 

=IF(OR(ISBLANK($B4),VLOOKUP($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))

Returning #N/A
 

=IF(ISBLANK($B4),"",IF(VLOOKUP($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))

Returning #N/A
 

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

Returning #N/A
 

Thank you sir

Returning #N/A
 

Thank you sir