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

Hi, I am looking for quick coaching on what I believe is the SUMPRODUCT formula, for doing a lookup that involves greater than or less than values in a target cell, to then return a specific value in a different cell. For example. I am measuring the value in B2, and depending if it is less than, equal to, or greater than a value in cell in c2, return the corresponding value from a table L4:N9. Kind of like a vlookup but different. Can you help with this? Should be quick and I am looking for assistance asap. Thank you!
Solved by M. J. in 11 mins
I need to find the the reporting structure in an employee data(managers and their subordinates in an excel data) I have tried to use vlookup formula all to no avail. I nee help urgently.
Solved by V. C. in 20 mins
i am having a couple little problems. I first need the date in cell b3 to stay at the date i started filling the information on the form. I also need the cell b23 to only do the VLOOKUP if cell b12 has data entered into it. my VLOOKUP formula works perfect and i have tried multiple different ways to only have it populate, with out any luck. I know i am missing something simple. please help.
Solved by K. J. in 29 mins
Hello I have an mlb spreadsheet that is in the works and I need help with doing a VLookUp. If the batter is facing a Left handed pitcher (If G2=L) I would like to pull data from Tab "Hitter stats Left" or if a batter is facing a Right handed pitcher (G2=R)... I would like it to pull data from tab "Hitter stats Right". Any help would be appreciated.
Solved by I. D. in 21 mins
I'm stuck in vlookup function in a specific condition, seeking for help or better function to solve the problem.
Solved by V. Q. in 20 mins
Hello need help with my excel chart. The Vlookup function and match are not working
Solved by Z. J. in 28 mins
I am trying to add a vlookup formula to a spreadsheet. Where it should return what it found, I can only see the formula. Help
Solved by E. E. in 16 mins
need help to find out what is wrong with this formula IF(AND(B11="20-29",D11="VO2max",E11="FEMALE"),VLOOKUP(F11,\$R\$78:\$T\$82,3,TRUE),""
Solved by F. F. in 13 mins
VLOOKUP(A5,'Data Input'!A\$4:Y\$392,20,FALSE) can someone help me to interpret this?
Solved by M. J. in 27 mins
Hi I was wondering If someone can please help me with extracting data from a spreadsheet, I am trying to use VLOOKUP but not having any luck I have a spreadsheet which has employees from 3 different companies with multiple entries against most employees. Only this which identifies employees is employee number e.g. A111111 So I need to extract data which belong to employees of 1 company out of 3. e.g. Below is how it looks like Emp_ID Date Product Sale price A111111 3/7/2017 Hair dryer \$150 A111112 3/7/2017 Hair cutter \$120 A111115 3/7/2017 Nail cutter \$12 A111112 3/7/2017 Nail polish \$11 A111112 3/7/2017 Hair cutter \$120 A111115 3/7/2017 Hair cutter \$120 A111112 3/7/2017 Hair cutter \$120 A111117 3/7/2017 Hair cutter \$120 Table 2 Company Employee ID Company 1 A111111 Company 2 A111112 Company 3 A111115 Company 3 A111117 Any help would be much appreciated
Solved by G. L. in 28 mins