I am using a vlookup in conjunction with data validation and named range.
The table being referenced is a product list. Two columns. First column is the name of the product 62 cells long, and the second column is a price formatted as currency.
small sample of list:
Hunter Pro C $200
Hunter PGP $29
etc... 62 cells long. I even sorted it name.
When I use the VLookup, data validation and named range. And I know I'm doing the correct formula with absolute references. It gives me random data from halfway down the lists. I don't have the exact formula with me today but will have it tomorrow night. I was using =vlookup(prodname,products!$A$2;$B$61,2,false)
That is what I think it was off the top of my head, but I could have a few characters wrong. It was supposed to reference the price of the part when I click it in the list selection.
Also, I had another question. When it does work correctly, when I change the product in the list, will it automatically change the price instantly? When it seemed like it was working the first time, I changed the list and the vlookup data stayed the same instead of instantly changing.
Any help would be greatly appreciated!
Thanks in advance for helping the new guy!
Matt
The table being referenced is a product list. Two columns. First column is the name of the product 62 cells long, and the second column is a price formatted as currency.
small sample of list:
Hunter Pro C $200
Hunter PGP $29
etc... 62 cells long. I even sorted it name.
When I use the VLookup, data validation and named range. And I know I'm doing the correct formula with absolute references. It gives me random data from halfway down the lists. I don't have the exact formula with me today but will have it tomorrow night. I was using =vlookup(prodname,products!$A$2;$B$61,2,false)
That is what I think it was off the top of my head, but I could have a few characters wrong. It was supposed to reference the price of the part when I click it in the list selection.
Also, I had another question. When it does work correctly, when I change the product in the list, will it automatically change the price instantly? When it seemed like it was working the first time, I changed the list and the vlookup data stayed the same instead of instantly changing.
Any help would be greatly appreciated!
Thanks in advance for helping the new guy!
Matt