Hello,

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?

Thanks.