Forum Discussion

Copper Contributor

May 13, 2020

Multiple Fields pulling into a summary form

Here is some sample data. I am trying to take this spreadsheet and pull the player name and salary to a summary form for that team. Example, Lewisberry chose Hank Aaron in rd 1 and Bill Castro in rd ...

draft order and spreadsheet auto pop_help.xlsx21 KB

excel

Formulas and Functions

ice12020

Copper Contributor

May 14, 2020

scutler3

Hey !

I have attached a possible solution for your query

Gives you the CORRECT results in all cases EXCEPT Lewisberry (may be due to First Row)

Can't seem to figure a way out of it SORRY!

Hopefully someone else can point out the mistake I made

Anyways cheers

draft order and spreadsheet auto pop_help.xlsx38 KB