To look up specific data in Excel you can use either the MATCH or INDEX function.
- In your Excel sheet, identify the range in which you wish to search for the desired data.
- Within that identified range, identify the specific value you would like to return.
- Use either the MATCH or INDEX function to return the precise row or column value.
- The returned value is then used to return the specific data from the particular row or column.