M
M.O.R.
Hello,
I would like to be able to look up a price depending on both color & count
of items.
My table looks like:
# red blue green black
1-5 .20 .30 .31 .32
6-20 .15 .26 .28 .28
Such that if I ordered 18 blue pens the value returned would be (.26)
It seems that I need a combination of both V & H Lookup.
I would like to be able to look up a price depending on both color & count
of items.
My table looks like:
# red blue green black
1-5 .20 .30 .31 .32
6-20 .15 .26 .28 .28
Such that if I ordered 18 blue pens the value returned would be (.26)
It seems that I need a combination of both V & H Lookup.