NESTED IF & VLOOKUP Formulas returning the correct data, but ...

[dante311]

Hi All -

Please find my "code" for a working IF(VLOOKUP... that does capture the data from the references table successfully. To start at the beginning, I have 5 value tables where data is being pulled from with a master table that is pulling the data from the 5 tables.

My issue is that cells that are empty in the data tables (from where data is pulled) is revealed as a "#N/A" in the master table and I want it to reveal a blank space...

=IF($A$2="Table 1",(VLOOKUP(MM,MM[Priority],1,0)),IF($A$2="Table 2",(VLOOKUP(RG,RG[Priority],1,0)),IF($A$2="Table 3",(VLOOKUP(CS,CS[Priority],1,0)),IF($A$2="Table 4",(VLOOKUP(JP,JP[Priority],1,0)),IF($A$2="Table 5",(VLOOKUP(JB,JB[Priority],1,0)),0)))))

I was hoping to return a 0 for false statements, which then I would create a new rule setting 0 = ;;; which returns a blank cell.

Any help?

Thank you in advance!

 

[Joe4]

You are welcome.

Note that all I did was what I recommended in my first reply; insert your original formula into the IFERROR formula (substituting your formula, except the equal sign, into the "your formula" part of that IFERROR construct).

So if it comes up again in the future, that is all you need to do.