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 . . .