Hello,

Not exactly sure what to put as the title, but this is what I am after.

What I want to do is:

Lookup C5 (green) is in sheet5 (other tab) in column A, search for small/medium/large in column I (blue) and then bring back the quantity in column Q (yellow)

Something like..

LOOKUP( C5 in column A, IF small/medium/large, bring back number of small/medium/large tshirts left)

See the example attached

Example 4.xlsxThanks