I have the spreadsheet below. I am running multiple VLOOKUP to return customer numbers. Some are returning multiple numbers (highlighted in green) and I would like to be able to write a formula in Column A that if all returned numbers in Row 2 were alike it would return 653180 in A2. And in Row 7, since there are differences, it would return
547309 , 547317. All help appreciated.
547309 , 547317. All help appreciated.
Book1 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | CustomerID | CustomerName | ORIGADD1 | ORIGADD2 | REVADD1 | REVADD2 | NAME1 | NAME2 | ||
2 | AAAAAAA | 653180 | 653180 | 653180 | ||||||
3 | ||||||||||
4 | ||||||||||
5 | ||||||||||
6 | ||||||||||
7 | BBBBBBBBB | 547309 | 547317 | 547309 | 547317 | 547309 | ||||
8 | ||||||||||
9 | CCCCCCCCC | 652140 | 652140 | |||||||
10 | DDDDDDDDD | 230772 | 230772 | |||||||
Sheet 1 |