Get instant live Excel expert VLOOKUP help

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I'm trying to find the "US WS" Price (United States Wholesale Price) via Vlookup, but it's just not working right. I don't know what the issue is. Please take a look at the vlookup steps and help me identify the error.
Solved by A. Q. in 27 mins
Good Night. I need help calculating down payments using VLOOKUP. I am a student at DeVry, I have tutor help, but there is none available at the moment and I have a big project to turn in this week. Help please
Solved by D. C. in 25 mins
I have a array with three columns and 38 rows. Column 1 has the holes of a golf tournament. (01A, 01B,02A, 02B, etc. through 18B) Column 2 is for the Golfers names and Column 3 the scores. Using VBA I what to search for a hole number and post a score in the third column. I have created a UserForm and ListBoxes to capture golfers names and and the Starting Hole numbers. The uses selects the starting hole number for ListBox1 and the Golfers Name from ListBox2. That codes is done, now I want to use that information to populate the array .I have tired VlookUp to find the Starting hole and locate the cell that I want to enter the Golfer but I haven't found a way to used all that to get the name in the array. Thanking y9ou in advance for any help you can offer.
Solved by A. U. in 11 mins
I'm trying to use a VLOOKUP formula between sheets and add it to a SUM formula to show in separate columns. I'm needing some help with vlookup basics, any pointers?
Solved by S. H. in 22 mins
I am trying to use the vlookup and or match /index formula on sheet two to get the code column filled out using the company name and city as a criteria and keep getting an error. Can you please help
Solved by T. Q. in 20 mins
I have three steps I must do which involves me dealing with vlookups and no matter what I look up, I am still confused and can't get my formula to work. I need help please! step 1: Switch to the worksheet “Internet user and pop. Table”. Use a VLOOKUP function in cell F2 so that it searches for the country in A2 (of current worksheet) that also appears within the “2016” worksheet and display its number of internet users. Expand the formula down to find the number of internet users for each country. Step 2:In the cell G2, use a similar VLOOKUP function to display the population for that country. Expand the formula down to find the population for each country. Step 3:In cell J2, use a formula to calculate the % of the population that uses the internet. Use the same calculation for each country.
Solved by D. Q. in 25 mins
Need VLOOKUP HELP. Trying to match the values in column A to a table range (AB:AD) . when the account number is found in the range, I want it to return the value in AD.
Solved by M. C. in 13 mins
My VLOOKUP does not work in Excel (though it seems to work in Google Sheets). I have an internet-linked query on worksheet 'Strokes Gained' that can't be edited. I need the VLOOKUP on the 'Master Spreadsheet' to draw from this internet-linked query table. I have sought help in the past from this site and the "fix" has been to edit the 'Strokes Gained' table -- this absolutely should not happen. Can you please help?
Solved by G. J. in 12 mins
I'm trying to recode stings into numbers; e.g. Sometimes=0, most of the time = 1, all the time =2. I used the VLOOKUP function, but it doesn't convert the "most of the time" and "all the time" variables. Can you help me?
Solved by V. D. in 16 mins
I am using vlookup function, in 2 worksheets, and I cannot copy the formula for more than a few rows until I get #n/a. I am using excel 2007 on a MAC. can you help?
Solved by I. J. in 12 mins