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

Need help with IF, MATCH, and excel LOOKUP function. Need to crosscheck 2 columns and once a match is found, return a value from the neighboring column.
Solved by Z. H. in 19 mins
i would like to apply vlookup. if there is 1 pc in transit and 2 pc in pending then result should be ETA date in 1 pending line and "No ETA" in second pending lines.
Solved by G. D. in 14 mins
When I do a vlookup and then copy the formula it copies the same result in the remaining cells. What do I need to do to have the actual result listed? thank you.
Solved by S. H. in 17 mins
I would like to have a cell look up a value on another sheet in a workbook and if the number is there and is greater than 0, then have the cell say "Yes." If the value is not there/is blank, then have the cell say "Budgeted Cost." Please find the formula I am currently using, below" =IF((VLOOKUP(B39,Tracker!\$A\$3:\$N\$200,14,FALSE)>0),"Yes","Budgeted Cost")
Solved by E. H. in 19 mins
Hi, I have a sheet which is using VLOOKUP to get data from a salary field linked by an ID number which is on another sheet associated with the salary The problem I have is that we have multiple entries (rows) which have the same ID field so we essentially only have one row which displays the salary linked to the ID number but the others don't fetch the salary. What I want to do is have a formula which is basically 'IF the ID number matches the ID number of the row with the salary field filled in THEN copy the same salary to the empty fields on the other rows. To visualize: ID | Salary (fetched by VLOOKUP from ID) 1 | £100 2 | £110 3 | £105 3 | 3 | 4 | £120 5 | £150 As above the VLOOKUP doesn't fetch if the ID is the same (as the other sheet has only one instance of the ID) So I was wondering how to get excel to display the right number (£105) in the blank spots Thanks in advance
Solved by V. S. in 17 mins
I would like F17 to pull value from 'Tracker' sheet if G17 says "yes". If G17 says "Budgeted Cost" then I would like F17 to pull value from (=IFERROR(VLOOKUP(C17,'Unit Renovations'!\$C\$6:\$E\$11,2,FALSE),""))
Solved by E. A. in 12 mins
Q20 has a date that does not exist. I would like the formula: "=IFERROR(VLOOKUP(B20,MRB!\$D\$3:\$AP\$300,38,FALSE),"")" to leave the cell blank if the date does not yet exist. And if G20 says yes, I would like the entire row from B to S to hard code the numbers, that way they do not change in the future. Or is that even possible? Thank you so much! I cannot believe that I have not used your service before! I have spent hours on this worksheet and you guys resolve errors within minutes! So fantastic!
Solved by F. B. in 29 mins
I am using vlookup and between two sheets.I have converted the field to numbers ,but whenever i use the formula,I get #NV error
Solved by T. U. in 18 mins
Hello, the Master Tab pulls in data from specific cells in other tabs. Instead of typing in the cell location (e.g., H2), is there a way to use vlookup or hlookup to ID which specific cell to pull in?
Solved by C. H. in 18 mins
hello I want to make a time sheet in excel for the company employees its attached I don't want to create a separate file for each employee then multiple sheets in each file for each month I saw some files online where you create a drop down list for employees then whenever you choose an employee you get his own data in the same sheet is this related to conditional vlookup and can only be applied when the changes between employees data are only in formatting? is it related to VLOOKUP? I also want to apply the same concept to years/months so I can stay in the same sheet while viewing the details for all employees for whatever year or month I want thanks
Solved by T. S. in 29 mins