I have this formula below, where IFERROR, if the vlookup sheet does not have the document number on it it will show "Not posted "(But it does not mean everything is not posted, but it could mean its deleted), the formula works but I need to add it with formula that if cell B2 is "deleted" (this is the text content of the cell) then the result should be "deleted" instead of "Not Posted". I cannot seem to work this out cause it will show I have multiple arguments.
=IFERROR(VLOOKUP(O2,POSTED!C:I,7,0),"Not Posted")
=IFERROR(VLOOKUP(O2,POSTED!C:I,7,0),"Not Posted")