Searching three titels to get result

1. Searching three titels to get result

Hi

I want to be able to search three titles to get the corresponding result to those three titles.

As seen in the attachment if I wanted to search for Dog, Big, B the answer would be 6 or if I wanted to search cat, medium, A the answer would be 8

Three search.xlsx

Thanks

2. Re: Searching three titels to get result

With an pivot table.

See the attached file.

I wasn't able to upload a file yet.

I try it later.

I tried it again but no succes. 13.25 hour

3. Re: Searching three titels to get result

See the attachment

4. Re: Searching three titels to get result

How about if what I was looking for was in one cell that read Dog Big B for a result of 6 or Fish Medium A for a result of 1?

5. Re: Searching three titels to get result

Just Change the name in Cell "G3","H3" and "I3" as per your requirement

6. Re: Searching three titels to get result

I want to be able to search when the names are combined, not in three different cells. so in cell G3 the name will be "Dog Big B".

Any ideas?

7. Re: Searching three titels to get result

See the attached file with an pivot table.

8. Re: Searching three titels to get result

Thanks but the pivot table doesn't fit what I am trying to do, see the post above, I am trying to get a result with all three names are combined in one cell.

9. Re: Searching three titels to get result

=MAX(INDEX((\$B\$3:\$B\$12&" "&\$C\$3:\$C\$12&" "&\$D\$3:\$D\$12="DOG BIG B")*(\$E\$3:\$E\$12),0))
Try this formula

10. Re: Searching three titels to get result

In that case you can amend the criteria in the pivot table.

I bet the pivot table will suit your needs.

11. Re: Searching three titels to get result

That works, now for the final part of the equation. See the attachment I have taken out a few of the types so there is blanks (cell b5, b7 & b11) when these cells are blank I want the formula to take the cell to the left and consider that in the equation. So now the result im looking for is "2 Big B" with the answer being 12

Four search.xlsx.

12. Re: Searching three titels to get result

see the attached file

13. Re: Searching three titels to get result

Seems to be close

The equation needs to look at column B and if it is full use it but if it is empty use the column A that is side by side with the empty column B, this is the only time column A should be used.

Five search.xlsx

There are currently 1 users browsing this thread. (0 members and 1 guests)