Need info from 1 sheet auto populated in another

[Dandelion111]

Hi,

I'm setting up a small business and trying to create an excel doc to auto populate data after a sale is entered. I have on my first sheet a total list of products I will be selling( all with product codes, description and cost price) (pic 1). On the second sheet, i'm trying to set up a table to record sales. I want to set it up so when you select an item code in the first cell from a drop down box, the product information will populate in the next 3 cells (name, description, cost price). i can't work out how to do this in one hit...

can someone please help me =)

*also, i'm still learning my around excel so apologies if this is an easy one

 

[Skybluekid]

Hi

A VLOOKUP/XLOOKUP Formula will be good for this

For Example,
For the Description
On Sheet 2, =VLOOKUP(INventory ID,Table on Sheet1,2,0). For the rest of the columns, just change the 2 to the relevant column number on Sheet1)