VLOOKUP with 2 conditions

Options

Hi

I hope some one can help me :

I have 2 sheet one to enter data from form & other to record( update row )


i need formula to take start time from first sheet to update in second sheet wit tow condition ( name & date )??


thanks

Answers

  • Brent Wilson
    Brent Wilson ✭✭✭✭✭
    edited 06/24/22
    Options

    Something I have done in the past is a little trick to make each record unique.

    I create a helper column in both sheets with something like "=[Employee Name] + Date" then when you do the vlookup you lookup the unique value. This way there is only one record for the Employee and Date combination

    Brent C. Wilson, P.Eng, PMP, Prince2

    Facilityy Professional Services Inc.

    http://www.facilityy.com

  • mohammad saaideh
    Options

    Thanks a lot ,, i try and its working now ..

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!