VLook Up across sheets with matching criteria

Options

Hi,

I am trying to do a vlook up or maybe a match/index to get information across sheets. I have a contact list in a registry sheet, that includes "Contact Name" and "Program Area". I need to pull the contact information into a Deliverables Sheet based on program area. So, pull Contact Name from Registry Sheet when Program Area from Deliverables Sheet and Registry Sheet match.

Both sheets look like this:

Contact Name | Program Area | (these are columns)

Thank you!

Answers

  • KPH
    KPH ✭✭✭✭✭✭
    Options

    Hi @Jbakertm

    If your Registry sheet looks like this

    On your Deliverables sheet you can use an INDEX and MATCH function combination like this in the Contact Name column

    =INDEX({Deliverables Contact Name}, MATCH([Program Area]@row, {Deliverables Program Area}, 0))

    This is a cross sheet formula so you need to set up the cross sheet references like this (you can name them whatever you want just make sure to use the same name in the function):

    and

    Now when you enter a program area the name will appear.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!