Large Nested IF with additional check

[JayUK]

Good Evening all

This is my first post so thank you in advance.

I have the following formula looking up if a cell has either TSE, DME, MAM etc then vlooking up a table with a corresponding code against a post code.

This also looks up ad6 first to check it's blank, if not it returns the AD6 code.

=IF(AD6=0,(IFERROR(IF(V6="DME",VLOOKUP(G:G,'CMF Pack'!A:K,10,FALSE),IF(V6="TSE",VLOOKUP(G:G,'CMF Pack'!A:K,9,FALSE),IF(V6="MAM",VLOOKUP(G:G,'CMF Pack'!A:E,5,FALSE),IF(V6="KAM",VLOOKUP(G:G,'CMF Pack'!A:G,7,FALSE),IF(V6="AM",VLOOKUP(G:G,'CMF Pack'!A:K,6,0)))))),"Bad Postcode")),AD6)

I now need this to check another cell, lets say AC6 as well to check it doesn't say "Rejected", if it does, it needs to not do the above, and simply =p6

so to simplify, if AD6 is blank, it looks up V6 and returns the Vlookup, if it's not blank it returns AD6, <- this works, -> the bit I am missing..... I need it to ignore these two commands if AC6 has "Rejected" in and return P6

Hope that makes sense

Thanks

[Glenn Kennedy]

Please read the yellow banner at the top of the page and post a SMALL sample sheet.