Pro Armor. From humble beginnings to industry leader, Pro Armor has been doing business for 13 years. Located in Riverside, CA Pro Armor has quickly become a giant in the Off Road Industry.
Goal Seek in Excel: Instructions. 1  To use Goal Seek in Excel, click the âWhat-If Analysisâ button in the âData Toolsâ group on the âDataâ tab in the Ribbon.  Select the âGoal Seekâ¦â command from the drop-down menu to open the âGoal Seekâ dialog box.
This will tell the LOOKUP function what value to look for in our column. The next value we need to enter is the LOOKUP vector. This is the column or row that Excel must scan to find the value we are searching for. So we want to tell Excel to scan column B from row 6 to 10 to see if it can locate the value we need. Finally the result vector is used to specify the return value if Excel finds the value. The results we want Excel to return in this case is the student name so the result vector in the data is contained in column C 6 to 10.