Forum Discussion

LGBroker's avatar
LGBroker
Copper Contributor
Jul 19, 2019
Solved

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 attemptin...
excel
Formulas and Functions
tauqeeracma's avatar
tauqeeracma
Iron Contributor
Jul 19, 2019

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

  • LGBroker's avatar
    LGBroker
    Copper Contributor
    Aug 08, 2019

    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!

      • LGBroker's avatar
        LGBroker
        Copper Contributor
        Aug 08, 2019

        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?

Resources