Thread: Vlookup range

Thanks Guys, I will look at the example and try to understand how it works. Not sure if this is the way to go, if valitation put in the price will I be able to change it sometimes?.Lets say a item is .89 and for a certain time I want it .93.I will play around a little with these questions. If I have 100 cells with valdation
will I have to copy formula to every cell,will it erase if I change the amount.
Z

Ok I undersand how Vlookup works some what,my question is how do I make the cells in column c,d just show $0.00 when there is nothing in column b. Is there a way to put vlookup code in the worksheet so I could change a amount in column c? If I do it now its deletes the code. I have a range of about 100 product cells on sheet1,can one code cover them all. Here is a new example.
Thanks

Thanks optomyst, I think I can make that work.
Z

So there is no way to put the formula in a cell range in vba? so if you did change it the next
time you open the workbook the formula would be back?

Would it be possible to put the formula that is in c2 in another hidden cell like J2?.So the next time you
open the sheet it would default back to the value in J2. Not sure how to make C2 value the same as J2
when you open the sheet?

I added an Override column so you have the option of changing the look up value. If you put anything in column E, it will override. If you erase the value it will default back to the look up value.

Thank You optomyst, I almost gave up. I"ve been playing around for days and could not find a way with
the existing form. This will work with some changes to my form. I just need to find a way to hide the extra column
when I print the page. If I can do that I know this will work perfect.
Again Thank You
Z

set your print area to omit that column or move it outside your print range.. that should make it easy

Thanks again optomyst, you had some great suggestions. I going to
move it outside the page.
Thanks Z