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
Hello, I would like help with TAB "Data NWA and Budget OOMs" to modify the following formula in Column M, row 34
=IFERROR(VLOOKUP($O34,'Data - Pivot Hrs Cost'!$A:$D,4,0),"")
Solved by C. H. in 26 mins
Hello, in the attached spreadsheet, I will be pasting data from a separate source in the "Sheet 2" tab. I need to have the student numbers on "Sheet 2" pull the corresponding student name (first and last), room (column I), Grade Level (column W) and Course (column F) found on "Sheet 1". The results of this search can be displayed on either Sheet 2 or a new sheet (Sheet 3). Also, Sheet 1 has multiple rows associated with a single name. I will need to pull the class connected to "01-01" in Column L (PRDS). I attempted to use the VLOOKUP feature but continued to receive errors. Please help!
Solved by V. W. in 15 mins
Yes, please help me with using VLOOKUP to search my employees name with the matching name and date along with the two timings showing that shows when they go in and out.
Solved by S. F. in 27 mins
Hi, I am trying to compare 2 sheets in excel.
I wanted to use Vlookup but not sure how to set it up correctly.
So if an item on sheet 2, exists on sheet 1 (the master file), I want it to return a value in column 4 on sheet 1. Can someone please help?
Solved by B. B. in 21 mins
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 need help with a few formulas on a spreadsheet I'm working on.
1.) It seems like excel is counting the blank spaces in row F whenever the data drop tab is blank. Is there a way to set this to "0" instead?
2.) I believe I am trying to do a VLookup formula, but I'm not very familiar with it. I am trying to set it so the sheet will copy the employee's name to a separate list based on if they meet certain criteria.
Solved by O. Y. in 17 mins
I need help creating a VLOOKUP table. I am requesting that i could use the same expert as before, as they already have some information on my problem.
Solved by I. S. in 14 mins
Hi, I need help on a VLOOKUP table. I am requesting the same expert i had before as they know more about the problem than i care to explain again. Thank you
Solved by G. Q. in 30 mins
Hi, i need help on a VLOOKUP. I am requesting the same one as before as they know more information about my specific problem.
Solved by F. F. in 29 mins
Hi, I need help with a vlookup table. I will add the file as soon as i am matched with an expert as the last file i added was corrupt.
Solved by D. F. in 26 mins