a1 a2 a3 a4
X1 BX1 FX1 HX1
X2 BX2 FX2 HX2
X3 BX3 FX3 HX3
X4 BX4 FX4 HX4
X5 BX5 FX5 HX5
X6 BX6 FX6 HX6
X7 BX7 FX7 HX7
X8 BX8 FX8 HX8
X9 BX9 FX9 HX9
X10 BX10 FX10 HX10

I want to be able to search through one field for a certain repeating
variable(the number of repeats varies) and return a value from another field.
So, if I had a list of locations that were in different regions across the
country, I want to see for each region, the number of doors each location has
added, and then I want to see the number of windows in each location.

Thanks

--
I need so much help, but right now, some Excel help will suffice!!