Hi All,

I am unable to upload a test sheet at the moment but Imagine Sheet 1 has 2 columns, Column A lists AREA numbers (i.e AREA A, AREA B etc), Column B lists the branch numbers in those area's (I.e EB101, RF230, CD605).
On sheet 2 i have a Cell (C2) where i want to enter an AREA number and then on the same sheet in B7:B20 i am trying to put an equation in that will list all the Branch numbers in that Area, I have started using the SMALL function in order to get the row numbers...

=SMALL(IF(Sheet1!$A$2:$A$100=Sheet2!$C$2,ROW(Sheet1!$A$2:$A$100)),ROW(1:1))

i am pretty sure i need to use the INDEX funtion at the beggning in order to show the contents of the Cell that the Small function has found the row number for but have no idea how to get it to work.

Any idea's?

Thanks