Thread: Price Grid
View Single Post
  #1   Report Post  
excelotard
 
Posts: n/a
Default Price Grid

I've never done this before, so please be gentle with me.
I have price info in a grid, and I need a 40 line invoice where I can just
type in the SKU which is essentially a combination of the data name from the
COLOR and STYLE number from the grid as shown as an example

STYLES - 101 102 103 104 104 106 107 108
COLORS BLUE .50 .75 1.10 .85 .60 .20 .42 .37
RED .50 .75 1.10 N/A .60 .20 .42.
N/A
GREEN .65 .85 N/A .95 .75 .30 N/A
..42
YELL .40 .65 N/A .75 .55 .30 .37
N/A

SKU example: BLUE102 = .75

How do I set this up?
The entire data set is 5000 items if I list each SKU as a combined
COLOR/STYLE with it's coresponding value beside it for a vlookup search.

any suggestions please?

ORA