Take a look VLOOKUP function or INDEX and MATCH function in Excel Help menu


"gcastle" wrote:

I receive a spreadsheet of stores within our company with store number,
address, phone, manager, etc info in that spreadsheet. I want to be able to
copy address, phone number and other cells from this spreadsheet into cells
in a row of a second spreadsheet automatically when the store number is
entered into the store number cell of the second spreadsheet.

Anyone know how to do this?