VLookup

[studentmomma]

I'm trying to do an assignment and I've been stuck on one step for an hour now.

My workbook has 2 sheets. A Purchase order and a product list. The Product List shows the model, type and price of the items that are available.

I need to do a look up function to look up the model type off the product list and put it into my purchase order. How do I do this?

PC-Market

Modems
Product ID:
1050

Type: ISDN/DSL
Model:
Price:

Quantity


Shipping Options


Shipping Cost

Total Cost





To get the product type my professor said to type in=VLOOKUP(B5,ProductPrice,2)

I cannot figure out how to modify that string to get my model to come up Any tips?

Thanks

[vlady]

Hello
Welcome to the forum.
Like this?
Created using excel 2007

[studentmomma]

No it should bring up Eicon DIVA T/A ISDN Modem U interface external (RJ-45) ISDN modem
Instead depending on what I type in I get NA or REF or Lucent DSLPipe-HST 1-port SDSL-based router/bridge, 4 Ethernet, and 1 console port 2.3MB


I don't understand how I can get an answer but not be able to get the right answer

[vlady]

Better Post a dummy file so others can work on it.
Thanks.

[studentmomma]

Will this work?

Thanks!

[MarvinP]

Hi studentmomma,

From your equation of

Please Login or Register  to view this content.

You must have a Named Range somewhere called "ProductPrice". Do you have such a range defined in your worksheet?

Also - Because you don't have a 4th argument (True or False) your data in ProductPrice must be sorted from small to big or from A to Z.

Look at this tutorial and click on Next to get all the instructions.

[MarvinP]

Hi,
See if the attached helps solve this problem.

Note the $B$3 which is absolute addressing.

[vlady]

And another one here..

[studentmomma]

Thanks everyone! That was the hardest assignment I've had all semester.

It is done now