I'm in Excel at college and I have to make a vlookup or lookup formula (not
specific on which) and I need help. This is the question from the textbook:
"In the purchase order worksheet, Product ID numbers will be entered in B5.
Create a lookup function to display the product type in C7, model name in C8,
and price in C9. Product information is displayed in the product list
worksheet." So I'm working with two worksheets. How do I start my lookup
function? This is an example of what I have so far: VLOOKUP('Product
List'!A8,Product Price[ID],1) That brings up the ID number from Product List
A8 only and puts it in B5 on Purchase Order sheet. I don't know why for the
second part it changed Product list to Product price either. If you can make
sense of this please help. Assignment is due Friday and it's an online class
so I don't see the teacher and she barely emails to help. Thank you Maria