Automatically Populate Fields

[tqdinh22]

Hello,

I am trying to create a spreadsheet to log in current purchase orders for my company. What I am trying to accomplish is to be able to type in the order number in the first column and have several other fields in the row automatically populate ("account manager" "sales rep" etc.) Perhaps pulling info from another data sheet. Is this possible with excel?

Thank you

[Bearacade]

Have you looked into lookup, vlookup or hlookup?