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!