Just a quick Note.

F7:F100 would be Col A in the example and G7:G100 would be col B.#

Thanks

Martin

"Martinc126" wrote:

Hello,

I'm not sure if this can be Done but hopefully you'll be able to help. I've
been trying to do this for weeks now.

Bascially I have a number of stores in different areas.

For example

COL A COL B
AREA1 StoreName1
AREA1 StoreName2
AREA1 StoreName3
AREA1 StoreName4
AREA1 StoreName5
AREA2 StoreName1
AREA2 StoreName2
AREA2 StoreName3
AREA2 StoreName4
AREA2 StoreName5

However i want to display the data on another sheet by selecting which area
number.

I used the following
=LOOKUP(C3,F7:F100,G7:G100)

This only shows the last store name from the selected Area Number, But i
want it the list all stores with that area number, (C3) been where the area
number is enter.

Can you understand what i'm trying to ask.

Any help would be great.

Thanks

Martin