multiple results, multiple criteria - is there another way apart from arrays?

[stwigge]

Hi out there!

I would like to provide a search function, based on two values.

If it was a sum, I would be fine, as I would use sumproduct, however I am trying to return multiple results which are not sums.

I would like to attach a sheet - this would be the easiest way of explaining how to do this.
Is this possible?

Any help would be much appreciated!
Si

 

[Special-K99]

Example data ?

 

[stwigge]

Thanks

Unfortunately I mentioned that I don't seem to have the authority to upload a file, so that I can show you.

Anyone any ideas on this please?

thanks again

 

[Gerald Higgins]

You can't upload a sheet as such, but there are ways round this.

Take a look at the FAQs for this board for ideas on this.