Thank you for your reply.

TeeGee

"Tom Ogilvy" wrote:

Look in Excel help for Vlookup and Lookup worksheet functions.

--
Regards,
Tom Ogilvy


"TeeGee" wrote in message
...
Is it possible to have Excel "lookup" a value from another table and "fill
in" several cells according to the value found (similar to the lookup
table
feature in Access)? E.G. Look up and fill in Buyer's # found in another
table and fill in Buyer's Name, Address, Phone, Etc. accordingly.

I don't want to switch my data to Access if I don't need to.

Desparate . . .