IFERROR + IF + VLOOKUP HELP!

[Heaths23]

Hi, I'm trying to use this formula and I keep getting an error. =IFERROR(IF(FR19="Not Found","",(VLOOKUP(FF19,Proffit!$A$2:$H$621,2,FALSE),""))) Basically if "Not Found" is present in the cell I need the cell to be empty. Any help would be greatly appreciated.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(FR19="Not Found","",IFNA(VLOOKUP(FF19,Proffit!$A$2:$H$621,2,FALSE),""))

 

[Heaths23]

Hi & welcome to MrExcel.
How about

=IF(FR19="Not Found","",IFNA(VLOOKUP(FF19,Proffit!$A$2:$H$621,2,FALSE),""))

Almost, it displayed a "0". It's gotta be empty or the program I'm importing the sheet into will see it as a price of zero.

 

[Fluff]

In that case col B is empty for that lookup value.
Is col B numbers?

 

[Heaths23]

In that case col B is empty for that lookup value.
Is col B numbers?

Col B has a "Not Found" in it.

 

[Heaths23]

Col B has a "Not Found" in it. View attachment 49776

This is the formula I have setup for column B on most of the cells. =IFERROR(VLOOKUP(A141,SSV!$A$2:$G$25490,7,FALSE),IFERROR(VLOOKUP(A141,SEA!$A$2:$G$100852,7,FALSE),IFERROR(VLOOKUP(A141,ATV!$A$2:$G$100000,7,FALSE),"Not Found")))

 

[Fluff]

Either you have a blank cell in col B, or you have a 0 value.

 

[Heaths23]

Either you have a blank cell in col B, or you have a 0 value.

Maybe I'm explaining it wrong. I dont mind to share the excel sheet with you personally if you have an email I could send it to. Either way the cell in Column B it is referring to has a value of "Not Found" so I don't understand how the formula you gave me is returning 0.

 

[Fluff]

The formula will only return a 0 if col B on the proffit sheet is empty or 0. Check that you don't have more than one instance of the FF19 value in col A of the Proffit sheet.

 

[Heaths23]

The formula will only return a 0 if col B on the proffit sheet is empty or 0. Check that you don't have more than one instance of the FF19 value in col A of the Proffit sheet.