Something like

=VLOOKUP(A1,Sheet1!A1:E20,2,False)

will return column 2, the name.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Fiona" wrote in message
...
I have a file with two spreadsheets containing data. One
contains a list of user defined entries, the other I want
to summarise specific fields based upon the original
entries in S/sheet 1.

I am trying to use the lookup function to enter in
S/sheet 2 the value driven by a field in s/sheet 1.

Eg, S/sheet 1 has a client reference, names and other
details. On S/sheet 2 I only want the client reference,
name and one other field taken from fields in S/sheet 1.

ie. Lookupif(A1="1")then return value in B2

Something messy like that!