SOLVED
Home

Excel Spreadsheet cell (multiple issues)

%3CLINGO-SUB%20id%3D%22lingo-sub-764108%22%20slang%3D%22en-US%22%3EExcel%20Spreadsheet%20cell%20(multiple%20issues)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-764108%22%20slang%3D%22en-US%22%3E%3CP%3EI'll%20try%20to%20explain%20concisely%20what%20I%20am%20trying%20to%20do.%20I%20have%20reports%20from%20one%20company%20%26amp%3B%20reports%20from%20another%20-%20the%20information%20in%20the%20reports%20has%20one%20thing%20in%20common%3B%20an%20email%20address.%3C%2FP%3E%3CP%3EI'm%20attempting%20to%20automate%2C%20whereby%20on%20one%20worksheet%20file%20I%20can%20extract%20all%20the%20information%20in%20the%20row%20from%20one%20report%20source%20plus%20all%20the%20information%20in%20the%20row%20from%20the%202nd%20report%20source%20IF%20they%20have%20the%20email%20address%20in%20common.%20Is%20this%20even%20possible%3F%3C%2FP%3E%3CP%3ECan%20provide%20worksheets%20as%20example%20if%20this%20will%20help.%26nbsp%3B%3C%2FP%3E%3CP%3EAbsolute%20beginner%20here%2C%20btw.%3C%2FP%3E%3CP%3ECheers!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-764108%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-764269%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Spreadsheet%20cell%20(multiple%20issues)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-764269%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F378786%22%20target%3D%22_blank%22%3E%40LGBroker%3C%2FA%3EYes%2C%20its%20possible%20try%20the%20vlookup%20function.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-764369%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Spreadsheet%20cell%20(multiple%20issues)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-764369%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F378786%22%20target%3D%22_blank%22%3E%40LGBroker%3C%2FA%3E%2C%26nbsp%3B%20Attached%20please%20find%20a%20sample%20file%20that%20would%20help%20to%20explain%20Vlookup()%20functions.%20You%20can%20apply%20same%20formula%20in%20your%20sheets%20accordingly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20also%20share%20the%20file%20if%20you%20want%20me%20to%20incorporate%20this%20formula%20in%20that%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-794424%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Spreadsheet%20cell%20(multiple%20issues)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-794424%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou're%20brilliant!%26nbsp%3B%20I%20was%20unable%20to%20make%20it%20work%20however%20as%20needed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20attached%20a%20sample%20file%20with%20the%20various%20worksheets%20%26amp%3B%20what%20I'm%20attempting%20to%20consolidate%20-%20are%20you%20able%20to%20apply%20the%20relevant%20formula%20to%20make%20it%20work%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20assistance%20very%20much%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-794467%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Spreadsheet%20cell%20(multiple%20issues)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-794467%22%20slang%3D%22en-US%22%3E%3CP%3EHI%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F378786%22%20target%3D%22_blank%22%3E%40LGBroker%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20file%20is%20updated%20as%20per%20your%20requirements.%20Hope%20it%20will%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-794501%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Spreadsheet%20cell%20(multiple%20issues)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-794501%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Tauqueer%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20looks%20great%26nbsp%3B%20-%20but%20not%20quite%20what%20I%20was%20attempting.%3C%2FP%3E%3CP%3EI've%20input%20extra%20information%20under%20the%20two%20other%20worksheets%20-%20I'm%20trying%20to%20have%20this%20info%20(as%20per%20your%20last%20amendments)%20populate%20in%20the%20'applicant%20email'%20column%20(E)%20in%20the%20Consolidated%20worksheet%20IF%20the%20same%20email%20appears%20in%20Unsettled%20example%20worksheet%20in%20column%20E%20%26amp%3B%20column%20D%20in%20the%20Daily%20Extract%20Example%20worksheet.%3C%2FP%3E%3CP%3EI%20couldn't%20figure%20out%20how%20to%20make%20that%20work%20as%20is%20contingent%20upon%20two%20'IF's'.%3C%2FP%3E%3CP%3ECan%20it%20be%20done%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-794578%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Spreadsheet%20cell%20(multiple%20issues)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-794578%22%20slang%3D%22en-US%22%3E%3CP%3EHI%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F378786%22%20target%3D%22_blank%22%3E%40LGBroker%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheck%20this%20file%2C%20hopefully%20it%20will%20match%20your%20requirements.%3C%2FP%3E%3CP%3EPlease%20let%20me%20know.%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-807569%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Spreadsheet%20cell%20(multiple%20issues)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-807569%22%20slang%3D%22en-US%22%3EHi%20Tauqueer%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI've%20discovered%20a%20further%20problem.%3CBR%20%2F%3E%3CBR%20%2F%3EIt's%20been%20set%20up%20so%20IF%20the%20email%20address%20occurs%20in%20either%20tab%20(%3DIFERROR(VLOOKUP('Unsettled%20example'!E4%2C'Daily%20extract%20example'!%24D%242%3A%24D%24142%2C1%2C0)%2C%22%22))%20but%20upon%20entering%20the%20information%20in%20the%20last%20spreadsheet%20under%20the%20Unsettled%20example%20tab%20%26amp%3B%20Daily%20Extract%20tabs%20it%20doesn't%20work.%20The%20formula%20needs%20to%20take%20into%20account%20the%20email%20address%20may%20appear%20anywhere%20under%20either%20of%20those%20tabs%20-%20if%20there%20is%20a%20match%2C%20then%20the%20corresponding%20info%20to%20that%20email%20address%20needs%20to%20populate.%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20was%20my%20intent%20at%20the%20start%20(hence%20my%20problems)%20-%20is%20this%20actually%20possible%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-807691%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Spreadsheet%20cell%20(multiple%20issues)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-807691%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-807692%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Spreadsheet%20cell%20(multiple%20issues)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-807692%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3B-%20sorry%20tauqueer%2C%20incomplete%20spreadsheet%20was%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-807731%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Spreadsheet%20cell%20(multiple%20issues)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-807731%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F378786%22%20target%3D%22_blank%22%3E%40LGBroker%3C%2FA%3E%26nbsp%3BI%20think%20data%20was%20not%20populating%20because%20you%20added%20some%20new%20columns%20and%20that%20disconnect%20the%20link%20in%20'Consolidated'%20tab.%3C%2FP%3E%3CP%3EAnyhow%2C%20I%20have%20updated%20the%20file%20and%20now%20all%20required%20data%20is%20appearing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
LGBroker
Occasional Contributor

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

Hi@LGBroker Yes, its possible try the vlookup function.

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!

HI@LGBroker 

 

Your file is updated as per your requirements. Hope it will help.

 

Tauqeer

Highlighted

@tauqeeracma 

Hi Tauqueer, 

 

It looks great  - but not quite what I was attempting.

I've input extra information under the two other worksheets - I'm trying to have this info (as per your last amendments) populate in the 'applicant email' column (E) in the Consolidated worksheet IF the same email appears in Unsettled example worksheet in column E & column D in the Daily Extract Example worksheet.

I couldn't figure out how to make that work as is contingent upon two 'IF's'.

Can it be done?

Solution

HI@LGBroker 

 

Check this file, hopefully it will match your requirements.

Please let me know.

Tauqeer

Hi Tauqueer,

I've discovered a further problem.

It's been set up so IF the email address occurs in either tab (=IFERROR(VLOOKUP('Unsettled example'!E4,'Daily extract example'!$D$2:$D$142,1,0),"")) but upon entering the information in the last spreadsheet under the Unsettled example tab & Daily Extract tabs it doesn't work. The formula needs to take into account the email address may appear anywhere under either of those tabs - if there is a match, then the corresponding info to that email address needs to populate.

This was my intent at the start (hence my problems) - is this actually possible?

@tauqeeracma - sorry tauqueer, incomplete spreadsheet was attached.

@LGBroker I think data was not populating because you added some new columns and that disconnect the link in 'Consolidated' tab.

Anyhow, I have updated the file and now all required data is appearing.

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies