I am trying to automate my model, and the only thing I can think of is creating if statements
ie if I type in Wizards in Cell A30 then it will pull the necessary information from the spreadsheet above to calculate what I want it to, the only problem is there are 30 teams in the league so an If statement is kind of tedious
something like if(A30='Wizards' then B30 = ... etc) but do that 30 times
I was curious if there is some sort of search function or anything in Excel that would search from A2:A31 for a specific string, and if it is found then apply calculations?
Or would I have to code this?
ie if I type in Wizards in Cell A30 then it will pull the necessary information from the spreadsheet above to calculate what I want it to, the only problem is there are 30 teams in the league so an If statement is kind of tedious
something like if(A30='Wizards' then B30 = ... etc) but do that 30 times
I was curious if there is some sort of search function or anything in Excel that would search from A2:A31 for a specific string, and if it is found then apply calculations?
Or would I have to code this?