Disable Vlook Up if a row contains "SOLD"

Cannot edit the cell you have the vlookup function in. I don't know what you have done here, but everytime I place the cursor in that cell, it immediately jumps down one cell and over to the right. Until this is rectified, I can offer no help with this issue.

In O11 =IF(ISBLANK(B11),"",IF(VLOOKUP(B11,PRODUCT!A4:P20,16,FALSE)="SOLD","",VLOOKUP(B11,test.xlsm!All,4,FALSE)))

I don't understand this.

The problem is that If i want to cross check the invoice then i do not get the details as it disables VLOOKUP.

If vlookup is a formula in your worksheet, how is it disabled. Show me the specifics.

And showing me a picture is no help as I cannot see nor understand what is happening in a picture. You must explain in clear English with examples of what steps you take and what is actually happening. Here is a picture of a solution, not yours. Can you tell what is happening. No, and neither can I.

Data Range

A

B

C

D

E

F

G

H

I

J

K

L

1

NAME

DESCRIPTION

GUID

IS MISSING?

FULL PATH

2

VBA

Visual Basic For Applications

{000204EF-0000-0000-C000-000000000046}

FALSE

C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7.1\VBE7.DLL

3

Excel

Microsoft Excel 16.0 Object Library

{00020813-0000-0000-C000-000000000046}

FALSE

C:\Program Files (x86)\Microsoft Office\Root\Office16\EXCEL.EXE

4

stdole

OLE Automation

{00020430-0000-0000-C000-000000000046}

FALSE

C:\Windows\SysWOW64\stdole2.tlb

5

Office

Microsoft Office 16.0 Object Library

{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}

FALSE

C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16\MSO.DLL

6

MSForms

Microsoft Forms 2.0 Object Library

{0D452EE1-E08F-101A-852E-02608C4D0BB4}

FALSE

C:\WINDOWS\SysWoW64\FM20.DLL

7

MSComCtl2

Microsoft Windows Common Controls-2 6.0 (SP6)

{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}

FALSE

c:\windows\SysWow64\MSCOMCT2.ocx

8

VBIDE

Microsoft Visual Basic for Applications Extensibility 5.3

{0002E157-0000-0000-C000-000000000046}

FALSE

C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB