need to fill in rows based on column a information

I have attached a file for reference.

I have several products that have different price points based on how it is shipper per case. I need the pricing information to auto populate based on the product name. I am unsure how to start this project,. I thought about doing IF statements, but there could be 20-30 different products per job and I am hoping there is a better way to begin. Thank you in advance for your help!

Hi,
I suggest to create sheet2 (product description and unit price), in sheet1 to get the price use the following formula:

=VLOOKUP($A2;Sheet2!$A$2:$B$6;2;FALSE)

copy the above formula down to the unit price column in sheet1

Thanks

Attachment:Revised reference-file.xlsx

I will need all of the information to populate. For example, sheet one will only have the headings, and I will enter a
product name i.e. "product 3". I then need the other 4 columns to fill in based on the information in the data set (as you suggested will be on sheet 2).

Thank you! This will save me so much time and effort. Such a simple thing. Can't believe I didn't see it.