I have spread sheet with Name of player in Row and his career highlights in column. I wanted to fetch particular details of player in one click so I created the combo box from form control. Combo box will give list of player and respective position in input range. Using if statement the data will be fetched to show particular details of player. I got what I wanted using simple "if" statement.
In my actual spread sheet the column and rows are more than 15. Is there any better alternate formula or neat formula for this?
In my actual spread sheet the column and rows are more than 15. Is there any better alternate formula or neat formula for this?
