How to combine IF, IFERROR & VLOOKUP? Or Alternative

[hakunamatata167]

Hi All,

I currently have a sheet where I need to check if an invoice number is on a categorisation sheet and if so, to return the Priority assigned to it.

I have a IFERROR & VLOOKUP combo formula which will either return the Priority if the invoice number is there, or return "Not Listed" if the invoive number if it is not listed on the categorisation sheet.

However, there are some invoices listed on the categorisation sheet, which do not have a priority assigned. This means, with the current formula, for these invoices a value of zero is returned.

Is there a way to add to the formula so that any zero's instead show as "No Priority"?

Current formula is =IFERROR(VLOOKUP(...................),"Not Listed")

[etaf]

IFERROR ( IF ( Vlookup() = 0, "No Priority", Vlookup() ) , "Not Listed")

[Sam Capricci]

this is one way... =IF(IFERROR(VLOOKUP(A2,C:C,1,FALSE),"")="","Not Listed","")

or this... or =IF(IFERROR(VLOOKUP(A10,C:C,1,FALSE),"")="","Not Listed",VLOOKUP(A10,C:C,1,FALSE))