Re: Identify a number as being between two values
Alright guys I and a friend at work figured out how to do it in a round about way
I used to concatenate function and if functions to make the type of label and media into a part number. Also I used if functions to assign numbers to price breaks and I added that onto the part number as well. Then I used vlookup to match the part number the corresponding row and it populated the price. God do I love Excel and I love it even more when I bend it to my will!!!!
Sorry I got a little megolomanical there.....but thank you Richie. Your suggestion sparked the idea for me