Forum Discussion
Excel Spreadsheet cell (multiple issues)
I'll try to explain concisely what I am trying to do. I have reports from one company & reports from another - the information in the reports has one thing in common; an email address.
I'm attempting to automate, whereby on one worksheet file I can extract all the information in the row from one report source plus all the information in the row from the 2nd report source IF they have the email address in common. Is this even possible?
Can provide worksheets as example if this will help.
Absolute beginner here, btw.
Cheers!
9 Replies
Hello LGBroker, Attached please find a sample file that would help to explain Vlookup() functions. You can apply same formula in your sheets accordingly.
You may also share the file if you want me to incorporate this formula in that file.
Thanks,
Tauqeer
Hi tauqeeracma ,
You're brilliant! I was unable to make it work however as needed.
I've attached a sample file with the various worksheets & what I'm attempting to consolidate - are you able to apply the relevant formula to make it work?
Your assistance very much appreciated!
HiLGBroker Yes, its possible try the vlookup function.
