Get instant live Excel expert help with VLOOKUP functions

“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 stuck on number 9 about the VLOOKUP with the minimum down payment required.I put in =VLOOKUP(F4,$A$15:$C$18$,2,FALSE.... i dont know how to multiply the whole thing by C4 because when i do its an error, did u even set it up right?
Solved by B. B. in 19 mins
Here is what I'm trying to do: This is a travel grid for my office. When I mark someone in a specific hotel, I would like that hotel's rate to show up in the rate column. I think VLOOKUP would be the easiest. Or make this into a table and use VLOOKUP with a drop box option. I don't know. An added bonus would be that when I run out of a certain room type (NK, NQQ, etc) it no longer becomes a drop box option. Say the hotel only has 10 Non-smoking Kings available. Once I allocate those 10, the option is no longer available.
Solved by K. W. in 22 mins
I have list of tickets data and need to apply Vlookup and IF Statement to it
Solved by M. L. in 18 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 am trying to understand how a a particular formula works VLOOKUP(list,N:O,2,FALSE)*IF(G19>0,G19,1) I just started a new job and I am trying to understand how the formula placed in front of me interpretes. =INDEX(LIST1,MATCH(0,COUNTIF($N$14:N18,LIST1),0))
Solved by I. Y. in 12 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
VLookup reporting n/a when trying to match a date/time in an array. It works some times and not others. Relevant cells are i1063:l1067. AI1063:AI1067 confirm that the value of the lookup value is the same as the value in the array but still get random n/a's. There is no pasted data in the sheet and I have tested the most common n/a errors. Index/Match displays same problem.
Solved by K. S. 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
using vlookup, look at the values in column C and Column K and if a match is found, pull match adjacent info from Column J and place the value in column D
Solved by E. E. in 19 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