Forum Discussion
Searching for duplicate numbers across multiple spreadsheets in workbook
Hi, I've searched here as well as on the internet and have not been able to find guidance. We have a workbook we track invoices each month. Each month we start a new spreadsheet by copying the...
Im not sure if this formula works in Excel on Mac, don’t have a Mac.
You can use maybe a formula to check if an invoice number has been previously used in another sheet the VLOOKUP function.
For example, if you have a list of invoice numbers in column A of Sheet1 and you want to check if an invoice number entered in cell A2 of Sheet2 has been previously used,
you can use the following formula in cell B2 of Sheet2: =IFERROR(VLOOKUP(A2,Sheet1!A:A,1,FALSE),"No Match").
This formula will return the invoice number if it is found in column A of Sheet1
and “No Match” if it is not found.
Hope its helps!
Thank youNikolinoDE working with your response now to see if that works.