Retrieve Data From Another Sheet Based On Cell Value

[JIMBOB77]

Hi
I am trying to retrieve data from a separate sheet based on cell value.

Eg

In my summary sheet Column A has client names
I then have separate sheets - one for each client.

If Cell A1 Contains A Client Called "Big City"
In Cell B1 I want to show data from Cell F6 in a sheet called "Big City"

If name in A1 changes to "Small City"
Then B1 should now show data from a sheet called "Small City"

(Know this sounds a bit far fetched but its part a bigger project which would take far too long to explain)

Thanks

 

[njimack]

=indirect(address(6,6,,,a1))

 

[JIMBOB77]

Thanks Neil
Can you expand on function
Eg Im assuming that the 6's refer to Column 6 : Row 6????

 

[njimack]

Yes that's right. There's a shorter version which allows you to enter it as "F6", but it's easier to increment rows and columns by keeping to numbers rather than letters.