Nesting IFERROR, IF, VLOOKUP

[shebe228]

This may not be possible but is there a way to combine these two fomulas together into 1?

=IFERROR(VLOOKUP(W2,'[REMOVE.xlsx]Bad Data'!$A:$C,3,0),"")

=IF(X2=0,"REMOVE","")

 

[Jonmo1]

Can you be more specific?

If I had to guess, I'd say you probably want

=IF(X2=0,"REMOVE",IFERROR(VLOOKUP(W2,'[REMOVE.xlsx]Bad Data'!$A:$C,3,0),""))

 

[crazydragon84]

you need to give more context. i have no idea whats in X and W and in Bad Data, and what you are trying to accomplish

 

[shebe228]

W lists tax IDs. We have a list of Tax IDs in Bad Data that we want to remove from the report. The Bad Data report lists the tax id in column A, a description in B, and "REMOVE" in column C.

X is out of network bills. I want to exclude all tax ids with 0 out of network bills. The ultimate goal is to sort this table to have all of the stuff I want to remove at the top and then sort the remaining data in order by Bill Count.