Searching and returning cells based on multiple criteria

[LeeTee]

Hi All


I'm pretty new to excel and would really appreciate your input to solve a problem:


I am trying to formulate a vlookup query which uses multiple criteria and can't seem to get it right.


I have a data sheet which contains a cell called product type.

I want to create a formula on a separate worksheet which will search the datasheet for particular (multiple) product types and then return information from a specified column on the data sheet.


For example, I may want to search for certain types of toys from a list - cars, dolls, and trains only. I may then want it to return data from the 'colour' column of each toy that matches the description - cars, dolls, or trains.


Any suggestions that you can offer are much appreciated!

 

[Hui]

LeeTee


Firstly, Welcome to the Chandoo.org forums.

Please take note of the 3 Green Sticky posts at: http://chandoo.org/forums/

They give you lots of info on how best to use this site


I'd suggest you start by looking up some keywords in the Google Custom Search box (Top right of all Chandoo.org screens)

Try keywords like VLookup, Lookup Multi Criteria, Lookup Multi Conditions etc


To save a bit of time you may want to read:

http://chandoo.org/wp/tag/vlookup-week/


http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/

http://chandoo.org/wp/2011/05/26/advanced-sumproduct-queries/

 

[LeeTee]

Thanks for pointing me in the right direction Hui!


I'll have a play and see if I can make it work.