Good afternoon,
I have tried to use an IF statement using MATCH on this but it has not been working for me.
I have three worksheets containing invoice numbers
One is a Summary
The other two represent the East and West Region.
Each of the region worksheets contain invoice numbers from their respective region.
Then on the summary worksheet I want to be able to identify which region has those invoices as shown in Column B.
Column B on the Summary would show EAST, WEST, BOTH or NONE...
Can someone possibly help me with this formula.
I have attached an example of the spreadsheets I am working with.
Thank you !
Janet
I have tried to use an IF statement using MATCH on this but it has not been working for me.
I have three worksheets containing invoice numbers
One is a Summary
The other two represent the East and West Region.
Each of the region worksheets contain invoice numbers from their respective region.
Then on the summary worksheet I want to be able to identify which region has those invoices as shown in Column B.
Column B on the Summary would show EAST, WEST, BOTH or NONE...
Can someone possibly help me with this formula.
I have attached an example of the spreadsheets I am working with.
Thank you !
Janet