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

Hi i cant upload a macro enable spreadsheet? Is there a reason for this? I've uploaded the sheet with macros disabled. So you can see my problem. What i want to do is; - Export data from the 'Production' tab using a macro, which will fill the 'Data' tab, i've wrote a macro for this and it works fine. - The 'Data' tab has a 'update dates and times' macro which looks at the 'Report' tab to see what the date is and the dates and times adjust from the date input. I've written the macro and it works fine. - The remove spaces macro is where I'm having trouble. I'm looking to do this so that a vlookup will look at the data from the exported production macro and return a value in column M so. The issue i'm having with my macro is that the date and month alternate between dd/mm/yyyy and mm/dd/yyyy on every row so the vlookup doesnt work. Does this all make sense?
Solved by K. C. in 25 mins
I have a vlookup that will work when the search value is typed into the cell but when that number is populated through a forluma it doesnt work
Solved by E. E. in 24 mins
I can't get the vlookup for customers to work it has to show up as an exact match but I can't get the formula to show anything but NA its in column dc where I tried a vlookup
Solved by K. L. in 23 mins
Hi , how to use vlookup in excel 2016? I created a Vlookup and don't know why it is not working
Solved by C. C. in 14 mins
Trying to do a vlookup comparing last names but not getting any results.
Solved by E. E. in 24 mins
unable to get process VLOOKUP on a large file that I am unable to upload
Solved by X. A. in 28 mins
Having difficulty with multiple part numbers trying to bring them into a master sheet with vlookup
Solved by T. S. in 12 mins
Looking to use a drop down list which once a criteria is selected, a formula is produced not a value. Ie/ I have 23 IF AND formulas that I would like to be 'Looked up' once a user selects the relevant selection from the drop down list. VLookup will only produce the cell value not the formula?
Solved by C. J. in 11 mins
Need to do the vlookup and count the spaces in data
Solved by F. H. in 17 mins
formula to select data from a table, like VLOOKUP picking a name out on a specific date but been able to pick multiple names out for the same date. For example on the 18/07/17 there is 3 films out i would like excel to read the film list and list all the films for the 18th. at them moment i can only get it to read one film title not sure how to get the row underneath to pick out the next film title
Solved by F. A. in 11 mins