There are a number of neat tips that'll help you out when you're managing your Excel spreadsheets. For example, if you have one worksheet with names and phone numbers and another sheet with names and email addresses, you can put the email addresses next to the names and phone numbers by using VLOOKUP. Using VLOOKUP, you can not only search for individual values, but also combine two worksheets into one. Enter the value whose data you're searching for.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |