Want to use 2 IF, IS BLANK, VLOOPUP together

Hi everyone,

I am stuck with a small problem.

I dont know how to proceed.

I am attaching the worksheet for better understanding


In the "INVOICE" sheet -

Range B11:B31 is the range where I enter the product code and other information is automatically derieved through VLOOPUP
Range C11:C31 contains the product information. Currently I am using this formulae in these range =IF(ISBLANK(B11),"",VLOOKUP(B11,testinggggggggg.xlsx!All,2,FALSE))

In the "PRODUCT" sheet I enter the product code, product details, etc
In the "PRODUCT " Sheet -

Column O shows SOLD automatically if the product is sold ( Through VBA )

What I wanted is that in "INVOICE" sheet when i enter the product code in range "B11:B31" It must show "Error " or "N/A" if the product is sold earlier ( If Sheet"Product" - range"o" has "sold" in it.


Maybe I have to enter another IF in this:

=IF(ISBLANK(B11),"",VLOOKUP(B11,testinggggggggg.xlsx!All,2,FALSE))

Is it Possible?

Try

=IFERROR(IF(ISBLANK(B11),"",IF(VLOOKUP(B11,testinggggggggg.xlsx!All,15,FALSE)="Sold","Error",IF(ISBLANK(B11),"",VLOOKUP(B11,testinggggggggg.xlsx!All,2,FALSE)))),"")

Change "All" named range to A:O

Hey Thank you so much for replying

I am unable to put the formulae.

can you plz attach the worksheet and shoe me?

Thank you for your help

Hey I was able to implement it.

How do i do the same thing for Cell O11:O32?