I have a table in MS Excel and I am trying to write a query to look for data but with my lack of knowledge in excel it seems to be harder that I thought.
The spreadsheet look like this:
A B C D
1 STATE CAT PRODUCT COUNT
2 CA AFFL DS1 100
3 CA NAFFL DS2 120
I am trying to pull the COUNT data to display it in a seprate spreadsheet. I need to be able to pull data and say:
If A= CA And Product = DS1 AND CAT= ADDL THEN D
I tried doing VLOOKUP but it seems that it will only look in one column.
This seems to be very basic, atleast using SQL but it seems to be a different story in EXCEL.
What is the best way to get this done in excel?