VLook Up across sheets with matching criteria

Jbakertm

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!

KPH

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.