Get instant live Excel excel help and learn how to use VLOOKUP across multiple sheets

“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

trying to link datasets from multiple sheets and use vlookup
Solved by K. L. in 29 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 formatting 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
I'm writing a vlookup that is supposed to check for a single value across multiple worksheets and return the information I specified. I already got it to work for references to multiple sheets within the workbook by specifying those sheets in the named range, SheetList. However, what I need it to do is look at multiple separate workbooks instead of multiple separate sheets within the same workbook. I know I can get it to work if I just put the workbook names in the named range that the formula uses, but I can't figure out what conventions or syntax to use to name those workbooks.
Solved by C. Y. in 19 mins
i'm doing a vlookup across multiple sheets but i don't have a specific value to search on
Solved by O. F. in 15 mins