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
Have a look at the attached. An array formula (confirmed with Ctrl+Shft+Enter) does all the work for you. At least I think this is what you mean.
I would suggest "Multiple criteria lookup" as the title for your thread.
If I've been of help, please hit the star
Non-array formula
=SUMPRODUCT(--(Sheet5!$A$2:$A$17=$C5),--(Sheet5!$I$2:$I$17=E$4),Sheet5!$Q$2:$Q$17)
Life's a spreadsheet, Excel!
Say thanks, Click *
This is great, both work thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks