|Without more specific info the best I can offer is to look at the =LOOKUP, =VLOOKUP(), =HLOOKUP() family of functions.|
They allow you to returns a value from other locations and other sheets.
Other functions that may be of interest would be the =INDEX() & =MATCH()
Also, not to be one to reinvent the wheel, have you looked at some of the many
Look here for a start:
and of course here:
message edited by mmcconaghy