Get instant live Excel expert VLOOKUP help

sir, my name is shishpal. i required help on how to use vlookup in excel 2010

Hi. I have two lists with different information I am trying to merge. They both have a shared column ('mentor name'), but in one sheet there a number of duplicates of the name... which is making it hard to merge. Tried Vlookup, but there are some complicated variables that are making it not work. Need help figuring out where I'm going wrong. Thanks! -Dara

Vlookup, indexing; analysis data between several sheets help

hello, I think I need help with a vlookup multiple sheets. Can you help?

Hi, I have a list of customer account names and dates of orders placed for them. Some accounts have ordered multiple times, so there are different dates for the same account name. I am looking to make a table using that information that has a list of the same customer accounts, BUT next to each customer account name is their most recent placed order date. I'm attempting to use Vlookup, but I am having no luck whatsoever. I would really appreciate if you could help me out with this.

what is vlookup? I have the vlookup formula in the spreadsheet. I don't understand each argument in the formula. Please help!

I have a template 'time off spreadsheet log' that includes a VLOOKUP (that I did not set up) from a previous year's spreadsheet and I would like to copy and apply to my new spreadsheet, but I'm having a hard time updating to pull the correct data. I'm just getting a lot of N/As. I'm sure its relatively easy to update, just need a little help.

Design a workbook named sales_LastNameFirstName to help you track your weekly sales commission. Your name should list in cell A1 in an enlarged font size with a different color than the default color merged and centered across all columns used. Display in a labeled cell your weekly base pay as a salesperson. Display in a labeled cell the amount of commission earned the previous week. Your company pays commission based upon the number of sales made in the week. The commission rate is then multiplied by the weekly base pay to compute commission amount. An English description is given below of commission rates. Use that data to create a lookup table placed on the workbook. Add a box border around the lookup table. Number of Sales Commission Rate 1-9 3.0% 10-19 3.5% 20 or more 3.8% Include column headings for date, number of sales, commission rate, commission amount, and total pay. Format the column headings row with some border in a different color than the default color and each entry boldfaced and center-aligned in its cell. Include five rows of data for the five business days Monday - Friday. For the first row, enter a particular Monday date and for remaining rows, add 1 to the previous date to compute the new date. Use the VLOOKUP function to compute the commission rate for each day based on the number of sales. Compute the commission amount from the commission rate and the base weekly pay. Compute the total pay as the sum of base pay and commission amount. Under the rows add a labeled cell and display the sum of commission amounts. Use the IF function that compares commission amount earned this week to the previous week's value and reports some congratulatory message if the current amount exceeds the previous amount, and some other message otherwise. Format the message in boldface in the same font color as your name. Use Currency format with two decimals on all money amounts. Use Percentage format with one decimal on all percentage values. Insert a small money-related image to the right side of the row data to fit the size of the five rows. Rename Sheet1 appropriately and delete unused sheets. Add a header of your name in the left side, sheet name in the middle, and current date on the right side. Your workbook must be unique and reflect your own data and design.

i need help with a formula that allows me to find the same value in another workbook then enter another value from the row it find the match. i know vlookup allows me to find the match but i dont know how to get the other value after it find the match.

I need help doing a vlookup in excel. Can you help me.