Excel 2007 : Pre-populated fields

[missioncontrol]

Hello,

Brand new member, never posted anything from any site...

Trying to create on a spreadsheet where if I entered a item # (A1), it would pre-populated the Item title (B1) and price (C1). I have a list of all these field on a separate sheet. Any guildance on how to do this???

Thank you!

[DGagnon]

You can do this with VLOOKUP, here is an example

if your list is on Sheet2 in range A:C on sheet 1 you could do this:

In cell B1
=VLOOKUP(A1,Sheet2!A:C,2,0)

In cell C2
=VLOOKUP(A1,Sheet2!A:C,3,0)