Searching, Finding And Extract Data Based On Set Parameters

[mprice1988]

I have three parameters that users on my spreadsheet will be using. They will be searching using the 'Brand', 'MPAN' and 'Tariff' fields. I then have another sheet within the same workbook with all the data in it with columns headed of Brand', 'MPAN' and 'Tariff'. It has to be an excat match using those three parameters though. I would like the parameters the user selects on the first sheet to be searched and found on the second sheet, with the figures in the cells next to the search result getting fed back into a set cells back on the first page.

Is this possible?

[davesexcel]

I have three parameters that users on my spreadsheet will be using. They will be searching using the 'Brand', 'MPAN' and 'Tariff' fields. I then have another sheet within the same workbook with all the data in it with columns headed of Brand', 'MPAN' and 'Tariff'. It has to be an excat match using those three parameters though. I would like the parameters the user selects on the first sheet to be searched and found on the second sheet, with the figures in the cells next to the search result getting fed back into a set cells back on the first page.

Is this possible?

try googling "sumproduct 3 conditions",
If you need assistance, maybe attach a sample workbook

[mprice1988]

Hi Dave, How can i attach a workbook?

[davesexcel]

Hi Dave, How can i attach a workbook?

Click the paper clip icon, to attach a file, if the workbook is greater than 100kb then you will have to zip it first

[mprice1988]

Thanks for your help dave, its now attached.

[davesexcel]

Thanks for your help dave, its now attached.

This will find the values in column D when you enter the 3 different conditions:
You should be aware the more Brand MPAN Tariff
you add to those columns increases chances that you will not find a match

=SUMPRODUCT(--('Tariff''s'!$A$3:$A$10=$C$11),--('Tariff''s'!$B$3:$B$10=$C$12),--('Tariff''s'!$C$3:$C$10=$C$13),'Tariff''s'!$D$3:$D$10)