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!”
Here are some problems that our users have asked and received explanations on
Need help adding data to a worksheet most likely using a vlookup.
Solved by G. D. in 26 mins
MY VLOOKUP NEEDS PULL OUT A ID BUT IT IS PULLING BLANKS , MAYBE A INDEX CAN HELP FIX THIS?
Solved by A. U. in 30 mins
help on these two questions:
1 On the Client Transactions worksheet, in cell I3, use the VLOOKUP function to retrieve the per ticket cost for each transaction based on the trip city from the data on the Travel Packages worksheet multiplied by the number of guests. Format as Accounting with 2 decimals.
2.In cell J3, use a VLOOKUP function to determine the discount earned based on the cost of trip and the data on the Agency Data and Analysis worksheet. Format as Percentage with 1 decimal place.
Solved by K. U. in 19 mins
help with question
In cell J3, use a VLOOKUP function to figure out how to calculate the discount percentage in excel earned based on the cost of trip and the data on the Agency Data and Analysis worksheet. Format as Percentage with 1 decimal place.
Solved by E. E. in 18 mins
Hi, I've got two spreadsheets that I want to combine. They both have IDs in Column A, and then each different information in further columns. One spreadsheet has more cases then the other so that I cannot combine them easily after sorting alphabetically. I've tried VLOOKUP and MATCHINDEX but just can't make sense out of the formulas. Could you help me?
Solved by D. D. in 18 mins
I need help with a query but I am not totally sure if Vlookup can show more than record in a cell?
Solved by O. D. in 22 mins
in the above attached salary sheet we seperate to files with the name of A and B in the A File we have Employee Code, Name of employee and Punching Code where as in B File we have punching Code and Date of joining with blank coloumn of employee name. i wont employee name in b coloumn with the help of vlookup formula.
Solved by V. W. in 23 mins
I need a formula to put in the column B in the COST SUB TAB, calculating excel table subtotal per resource from Column B in the Cost Plan tab (the result needed is similar to a Pivot TableNot with Resources in the Row and the Sum ofForecastedUnits in the values, however i would like a formula instead the pivot table for a similar result).
Not sure if it's the SUMIF formula + vlookup the most appropriate or somethingelse. Please help me.
Solved by F. D. in 29 mins
I need a formula in the 2nd tab, to calculate the subtotal per resource from the 1st tab.
Not sure if it's the SUMIF formula + vlookup the most appropriate or somethingelse. Please help me.
Solved by V. E. in 27 mins
I need help with a VLOOKUP. How to do vlookup in excel 2013.
Solved by K. A. in 12 mins