vlookup from different sheets

I'm not at all sure what it is that you require. The columns that I think that you want from your description have formulae that work perfectly well and are not dependant upon the columns that I think that you don't want. I just deleted the columns that I think you don't want and the workbook appears to work properly.

If this is not what want indicate by column identification what you really want.

I think that I have done what you wanted but not sure. Instruction marked with *** I had no idea what you wanted.

The formula (as it is, with the data as it is) will take the first occurrence that satisfies the conditions of the formula. One way around this is to create a "serial number) that incorporates the date and time either with a helper column or by combining the number value with the associated time. An example would be something like A2&E2 and from your workbook that would give a serial number of 60950430341453.6364583333. The sort order by date might be an easy way to get around this kind of issue.

That is one possibility if it is necessary. It would take a bit of changing of your present data to make it work. You would have to decide if it is worth it or if it is really necessary.

Those are just "quick thoughts" and there is nearly always a way.

I have saved a copy of your data and will try to find a solution that is workable.

Do you have some examples where there are duplicates except for the dates? Some data that can be added to the present workbook would be appreciated.

Would it be possible to use the combination of NUMBER and NUMBER 1? I don't know the significance of either number but if a combination of the two numbers could solve the problem it might make it easier.

Thank you. This appears to be the same file as I was working on so will continue with that. I have identified several duplicate entries with different dates. I will work on this tomorrow when my brain wakes up again. Right now, I have hit a block in thinking. I am sure that it can be done. It is a matter of finding the best way.

This is about as well as I can do. There is a hidden column G on the second worksheet don't delete this because the calculations rely on it.

Oops, I forgot to hide column G on the second worksheet.....DON'T DELETE IT .... HIDE IT

All the ranges in the formulae will have to be increased to make it useable (add more data). I was going to do that but the file got to be too large too quickly. As it was, I had to trim the file down in order to upload it. I had comments and formulae to show my process which I had to delete.

Copy the formula on the second sheet column G down a few thousand rows.

Increase the ranges that have 10807 (I think ... from memory) to match the number of rows that you copy the formula in column G. If you copy down to row 15000, increase all the ranges in the formulae go to that row number so everything matches.

I will see what I can do about that. It will have to be a formula that I send to you because the workbook becomes too large to be able to be sent. I had to trim it down to the bare bones just to get it uploaded. There is much checking that I have to do yet.

The Previous Service Data is going to be difficult to check because so little of it matches.

One thing that you should take a look at is the Number and Number 1 columns. In a lot of cases, these values are matched pairs in that where a record has one of them, the other value is also there. This is duplication that will over time really slow down the processing of your data.

I will work on your workbook and get back to you. This could be a long process....but I hope not.

I have added support for the 3rd worksheet and extended the ranges in the formulae so that there is lots of room for new data entry.

I hope that you can unzip the file because using ZIP was the only way for me to upload the file.

I'm glad to have been of some help.

May only good things come your way.

Do you mean to extract data from the New Sheet in addition to the sheets that already have data extracted or do you mean to just extract the data from New Sheet without the other sheets?

It has been a few weeks since I worked on this so I will have to re-familiarize myself with the workbook and how it works. At first glance, it should be possible. How much work it will be, I don't know because I have to change some of the logic of the formulae to take into account the added worksheet.

The data on the New Sheet looks like the data on the BPO DATA worksheet. Can't this data just be added to the BPO DATA worksheet as I don't see any difference in it other than the length of the data?

OK, received your revised worksheet and incorporated the data into the previous version that I had been working on and the new data filled in all the blanks that were on the main worksheet.

I will try and ZIP the file and send it to you from my other computer that has WinZip installed and can get a smaller file after compression. I will do this first thing tomorrow morning as it is getting late here and I am quite tired.

I found what appears to work using your revised workbook. If there is data missing, just add it.

As far as I can tell, there shouldn't be any formulae in column I of BPO DATA. There are formulae in column H of BPO DATA and they can be deleted if you like as they were used to help develop other formulae.

Sorry that you were sick. I hope that you are well now.

The workbook isn't working because you can't just add a column in each worksheet and have it work. Doing so destroys a lot of the formulae references so the formulae don't return expected results.

All the data on the main worksheet is gone and so are the formulae. I will take a look at this in the morning as it is night right now. I will try and salvage what I can. This might be easy or next to impossible. Right now, I don't know.

I will get back to you.

I was extremely lucky. I incorporated the column you wanted then moved the helper column far out of the way. If you make changes to the workbook, make sure that you save the latest working copy so that you have a backup in case something goes wrong.

Never work on the active copy to make changes.