Forum Discussion
Advanced IF(AND) Formula help needed
Thank you all in advance for helping me with my issue! For this report, I would like to add text to a new column (IF) the invoice number matches a one of the Invoice numbers in my list. Allow me...
You may wrap VLOOKUP with IFNA, like this:
=IFNA(VLOOKUP(A3,InvoiceCodes,2,0),"")
The foregoing formula assumes that the data in Columns AF and AG are named InvoiceCodes.
=IFNA(VLOOKUP(A3,InvoiceCodes,2,0),"")
The foregoing formula assumes that the data in Columns AF and AG are named InvoiceCodes.