Expected Value not returned in Vlookup Statement combined with IF

[MrPink1986]

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

 

[mole999]

I think the No Price is because of the IFERROR, i.e there is an error the first IF is TRUE

 

[Aladin Akyurek]

Something like...

=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?

 

[MrPink1986]

Thanks - it worked perfectly. .

Something like...

=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?

 

[Aladin Akyurek]

Thanks - it worked perfectly. .

You are welcome. Thanks for providing feedback.