This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have this massive file that I work on every week. Each friday I run reports from other software and dump all the data into this excel file. Charts will then be created and distributed to the managers in the company. It's hard to explain what the issue is so please bear with me.
Tab 1 has a list of activity data for a single department (dept A). Basically it's who worked on the job, the date they did the job and the job number.
Tab 2 has a list of target hours for each job for multiple departments. The job number, the department number and the estimated target hours to complete the job. Using a vlookup formula I lookup the date on tab 1.
Tab 3 has a list of the jobs that were completed by a single department (dept A). Just the job number. Using formulas I lookup the date on tab 1 and the hours on tab 2.
My problem has 2 parts. First is that there are about 60 rows at the end of the data on tab 3 where the vlookup formula is not pulling the hours from tab 2 and it's not becaue the hours are not there. The hours are listed on tab 2. I think I figured out why this happened and that is because the Vlookup on tab 2 is not pulling the date from tab 1. Every row where the formula successfully pulls the hours from tab 2 has a date by it on tab 2.
The second part of my problem is that their is a vlookup formula on tab 2 and tab 3 that lookup the date from tab 1. These formulas are exactly the same, but it only works on tab 3 and not tab 2. WHY? This is what I need to fiigure out.
Again this problem only applies to about 60 rows at the end of the data on tab 3 which has at this point 5193 rows of data. I have tried sorting, deleting the formulas and re-entering them, copying the formulas from an area where it works and deleting the data and putting it back in. I have verified that the data the formulas are looking for is there, but can't figure out why it error's out.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi,
Just a hit in the dark but have you ensured that there are $ symbols in the second input of the VLOOKUP() function.
Hi!
Please upload the sample file to evaluate the problem and I will fix it for you. Leave the file link here so that we can download it, because the problem can have many causes.
Thanks!!