What is vlookup excel used for

Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Get first text value in a list. Since we In this example, the goal is to retrieve employee information from a table using only a partial match on the last name.

In other words, by typing "Aya" into cell H4, the formula should retrieve information about Michael Translate letters to numbers. At the core, this formula uses an array operation to generate an array of letters from the input text, translates each letter individually to a number, then joins all numbers together again and returns the output as a Income tax bracket calculation. Simple currency conversion.

The formula in this example converts amounts in USD to other currencies using currency codes. Available currencies and exact conversion rates can be adjusted by editing the values in the table on the right.

The core Abbreviate state names. You can download the example if you'd like to work along with this article. For example, if you have a list of products with prices, you could search for the price of a specific item. Once you learn how to use VLOOKUP, you'll be able to use it with larger, more complex spreadsheets, and that's when it will become truly useful. We'll add our formula to cell F2 , but you can add it to any blank cell. Then type the formula name.

Our arguments will need to be in parentheses, so type an open parenthesis. So far, it should look like this:. Now, we'll add our arguments. The first argument is the name of the item you're searching for, which in this case is Photo frame. Because the argument is text, we'll need to put it in double quotes:. The second argument is the cell range that contains the data.

Enter the value whose data you're searching for. 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. There are a number of neat tips that'll help you out when you're managing your Excel spreadsheets.