Microsoft Excel boasts a huge number of handy functions and utilities, many of which go unused by the average user. If you find yourself frequently needing to consult a table to find the same data, however, you'll probably want to learn how to use VLOOKUP. Short for "vertical lookup," VLOOKUP takes advantage of vertically-aligned tables to quickly find data associated with a value the user enters.
Using VLOOKUP, you can not only search for individual values, but also combine two worksheets into one. 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.
vlookup excel
vlookup شرح
vlookup match