The result is that Height is in column “2.”.Select all the cells across the top row of the table.Type “=MATCH(” and link to the cell containing “Height”… the criteria we want to look up.Use MATCH again to figure out what column Height is in. The result is that Kevin is in row “4.”.Select all the cells in the Name column (including the “Name” header).Type “=MATCH(” and link to the cell containing “Kevin”… the name we want to look up. ![]() Sticking with the same example as above, let’s use MATCH to figure out what row Kevin is in.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |