You guessed it right, you use VLOOKUP and summon excel to do the search and return with customer name. Now you need to find out which customer has the phone number “93”. Imagine you have all your customer contact information in one sheet in the range A1:D5000 in the format phone number, name, city and date of birth. VLOOKUP and MATCH are your way of asking excel to find a needle in haystack. Here is the syntax for these three very powerful functions in plain English: What are vlookup () and match () ? What is the syntax for Match, Vlookup and INDEX? Today, lets understand how to use these formulas better. In my opinion understanding VLOOKUP, INDEX and MATCH worksheet formulas can transform you from normal excel user to a data processing beast. It makes you to connect two different tabular lists and saves a ton of time. VLOOKUP may not make you tall, rich and famous, but learning it can certainly give you wings.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |