About Lookup and Vlookup


M

Maria

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
 
Ad

Advertisements

S

Sheeloo

Assumptions:
'Product List' sheet has
Col A: Id
B: product type
C: model name
D: price

type in C7 to get product type
=VLOOKUP(B5,'Product List'!A:D,2,FALSE)
type in C8 model name
=VLOOKUP(B5,'Product List'!A:D,3,FALSE)
type in C9 price
=VLOOKUP(B5,'Product List'!A:D,4,FALSE)
 
M

Maria

Thank you so much. I'm not at school so I can't try it tonight, but I'm eager
to do it tomorrow. Thanks again. You deserve that bronze. Maria

Sheeloo said:
Assumptions:
'Product List' sheet has
Col A: Id
B: product type
C: model name
D: price

type in C7 to get product type
=VLOOKUP(B5,'Product List'!A:D,2,FALSE)
type in C8 model name
=VLOOKUP(B5,'Product List'!A:D,3,FALSE)
type in C9 price
=VLOOKUP(B5,'Product List'!A:D,4,FALSE)


Maria said:
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
 
Ad

Advertisements

S

ShaneDevenshire

Hi,

Just a warning, if you use a reference like A:D, your instructor will know
you had help from an expert, and Sheeloo is an expert. If that is not a
problem, fine, otherwise change the reference to something like A1:D10 or the
exact range where your lookup table is.

--
Thanks,
Shane Devenshire


Maria said:
Thank you so much. I'm not at school so I can't try it tonight, but I'm eager
to do it tomorrow. Thanks again. You deserve that bronze. Maria

Sheeloo said:
Assumptions:
'Product List' sheet has
Col A: Id
B: product type
C: model name
D: price

type in C7 to get product type
=VLOOKUP(B5,'Product List'!A:D,2,FALSE)
type in C8 model name
=VLOOKUP(B5,'Product List'!A:D,3,FALSE)
type in C9 price
=VLOOKUP(B5,'Product List'!A:D,4,FALSE)


Maria said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookups and formats 3
VLookup 1
vlookup for max value or any value>0 1
Help with lookup 4
Auto display all related info 2
Lookup unsorted list 7
VLOOKUP in two worksheets 2
VLOOKUP 2

Top