Thread: Is there a way to merge information automatically from dissimilar tabs?

Can you attach an excerpt from your file -- with at least portions of the two tabs -- and an example of what you want in terms of results (done manually, of course)? Much more usefule than a picture. Thanks.

Don't know why I hadn't thought of that

Thanks for helping.

The attached works for your example. But what happens if there are, for example, two or more monitors in the Master list? This approach will only catch the first ...

In the actual data set it is broken out by person, but for privacy reasons I had to minify the information. But, yes, if the above was the actual data there would be some serious collision problems.

Thank you,
DW

So ... does this solution work or do you need further assistance? For example, do you need the formula to distinguish among users?

Sorry, I didn't see the attachment. You can tell I am not use to this forum. I will get a chance to test it later this afternoon, but from the looks of it, it should work. Either way I really appreciate your contribution and will let you know.

Thanks a bunch!!!!!

DW

Ok. I was wrong. I ran in to collision a lot more than expected, its a long list. How would I check it against both columns? Updated and uploaded the sample. Thanks a TON!

DW

Thought you might. Try the following (in Items!A2 and copied down):

=IF(SUMPRODUCT((Master!$B$2:$B$30=B2)*(Master!$A$2:$A$30)*(Master!$C$2:$C$30=C2))=0,"",SUMPRODUCT((Master!$B$2:$B$30=B2)*(Master!$A$2:$A$30)*(Master!$C$2:$C$30=C2)))

This isn't your first rodeo, is it?

Will try and get back to you.

Thank you!

DW

I can't find the bow emoticon, but if there was one I would use it!!! Thank you so much, you saved me a ton of time!

Happy to help.