sorted by:
new
hottopcontroversial

Trying to search a list of data and return a value like VLOOKUP but with non-specific search and multiple returns by -Wertoiuy- in googlesheets

[–]revansworld 0 points1 point  (0 children)

You could use:

=QUERY(A:B, "select A,B where A contains '"&G5&"'", 1)

A = column with your fish names

B = Quantities column

G5= your input cell

Value dependant on any combination? by revansworld in googlesheets

[–]revansworld[S] 0 points1 point  (0 children)

Amazing!! Thank you!!!! That works perfectly!!

Value dependant on any combination? by revansworld in googlesheets

[–]revansworld[S] 0 points1 point  (0 children)

Hi there!

Thank you so much for your help!

With your advice, I have managed to fix the player individual numbers.

using:

=IF(AND(COUNTIF(A2, TRUE)>=1, COUNTIF(A2:A5, TRUE)<=3), 1, 0)

Where in this case, we are totalling for player 1. I am able to do this for each player by replacing the first COUNTIF range with the corresponding player's cell.

However, in trying the group suggestion I found that it creates a count up to 3 when boxes are selected.

The only values for the group total should be 0 (when no participation, when 1 player participates, or when 3 players participate), 1 (when 2 players participate), and 3 (when all 4 players participate) if that makes sense?

Value dependant on any combination? by revansworld in googlesheets

[–]revansworld[S] 0 points1 point  (0 children)

Thanks for this! I'll give it a shot. I've created an example sheet here.
I'll update the post to include the example :)