Multiple and repeating returns help

[T2D2]

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.

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

 

[Domenic]

I hope I didn't misunderstand your question. Did you ask how to confirm the formula using CONTROL+SHIFT+ENTER or did you ask why it needs to be entered in that manner?