View Single Post
  #5   Report Post  
Cal
 
Posts: n/a
Default

Thank you guys SO much for your help. I managed to get it to work..
almost.
I have 2 questions more :)

First one is, I have a bunch of different items that have a percent in
their name. Even though they have different names is there anyway to
make it so when it sees a percent sign (%) it codes it always the
same. Should I just do a % with a code in my Products range and then
change VLOOKUP to "true"?

Second question is, I have some items that are coded with a blank cell
because there are so many different kinds. The VLOOKUP puts a 0 in
instead of a blank cell. This is not a big deal but is there anyway
to make it put a blank cell instead?

THANK YOU so much for your help, I must be truelly a computer geek as
this breakthru has made my weekend! :) x5