# Expected Value not returned in Vlookup Statement combined with IF

#### MrPink1986

##### Active Member
HI,

My formula below is not pulling back the expected value. I am running a vlookup to look first at the Vendor tab in my s/s. If this is Blank "", or an error it should look to the pRC tab and pull back the value if not here the comment "NO Price" is returned.

When running this formula I am getting back "NO Price" even though there is a vlaue in the PRC tab.

Any help greatly appreciated.

=IFERROR(IF(A14="","",IF(OR(VLOOKUP(E14,'Vendor'!\$A:\$AR,22,0)="",ISERROR(VLOOKUP(E14,'Vendor'!\$A:\$AR,22,0))),
VLOOKUP(A14,'PRC'!A:W,23,0),VLOOKUP(E14,'Vendor'!\$A:\$AR,22,0))),"No Price")

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
I think the No Price is because of the IFERROR, i.e there is an error the first IF is TRUE

Something like...
Rich (BB code):
``````=IF(A14="",
"",
IF(ISNUMBER(1/VLOOKUP(E14,'Vendor'!\$A:\$AR,22,0)),
VLOOKUP(E14,'Vendor'!\$A:\$AR,22,0),
IF(ISNUMBER(1/VLOOKUP(A14,'PRC'!A:W,23,0)),
VLOOKUP(A14,'PRC'!A:W,23,0),
"No Price")))
``````

Does this satisfy?

Thanks - it worked perfectly. .

Something like...
Rich (BB code):
``````=IF(A14="",
"",
IF(ISNUMBER(1/VLOOKUP(E14,'Vendor'!\$A:\$AR,22,0)),
VLOOKUP(E14,'Vendor'!\$A:\$AR,22,0),
IF(ISNUMBER(1/VLOOKUP(A14,'PRC'!A:W,23,0)),
VLOOKUP(A14,'PRC'!A:W,23,0),
"No Price")))
``````

Does this satisfy?

Thanks - it worked perfectly. .

You are welcome. Thanks for providing feedback.

Replies
5
Views
880
Replies
7
Views
476
Replies
3
Views
220
Replies
2
Views
604
Replies
17
Views
868

1,196,266
Messages
6,014,333
Members
441,816
Latest member
Klingon1960

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back