check he
http://www.cpearson.com/Excel/lookups.htm#DoubleLookup

You could also do it with the Index function (see XL help for description).
=INDEX(YourTable, Match(Size, SizeColumn, 0), Match(Qty, Qty Column,0))

Match is capable of exact match and approximate match lookups. I would
guess one price covers a range of quantity so you probably will want to check
help for a description of how Match works.

"chris" wrote:

i have a table matrix of garments by sizes for the same style going down the
column
across the columns are difference prices based on qty desire i know how to
look up the style only but how do you lookup the style and a size at the same
time based on qty desire.
ex.
the price for xl sizes are different than 2xl sizes for the same garment..