![]() ![]() For example, if the range A1:A3 contains the values 5, 7, and 38, then the formula =MATCH(7,A1:A3,0) returns the number 2, because 7 is the second item in the range. Use this function to search for an item in a range of cells, and then return the relative position of that item in the range. Check out this video about using VLOOKUP. ![]() For example, look up an employee's last name by her employee number, or find her phone number by looking up her last name (just like a telephone book). Use this function when you need to find things in a table or a range by row. Use this function when you need to look in a single row or column and find a value from the same position in a second row or column. Here's a video about using the IF function. Use this function to return one value if a condition is true and another value if it's false. Use this function to add the values in cells. ![]() Here are the 10 functions that people read about most. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |