Forum Discussion
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 ...
Hi scutler3
You can achieve the result using INDEX, SMALL & ROW functions. See attached worksheet.
The formula I used was
{=IFERROR(INDEX(Data, SMALL(IF($D$1=Data[FRANCHISE], ROW(Data[FRANCHISE])-ROW(Data[[#Headers],[FRANCHISE]])), ROW(1:1)),3),"" )}
It was entered as an array using pressing Ctrl+Shift+Enter for non-office 365 users.
I formated the information on tab "draft order" as a table named "Data", in case you are wondering where Data is coming from in the formula and the formula used table structured referencing.
I have also used data validation for the team selection on cell D1 in tab "Roster"
Hopefully, this is what you are looking for.
Cheers.