If Cell C has "X", fill Cell D with "Y"

[Tutsumi]

Good day,

Looking for a formula that could help with querying information.

Example for Sheet 1 (and I apologize, I can't post tables yet due to post limit):


Email Address Full Name Number
John.Doe John Doe 7212
Jane.Doe Jane Doe 7016


Sheet 2 has a list of numbers for each user.
7212 3025

If it finds 7212, then fill in Cell D, on Sheet 1 with 3025.

[alansidman]

I don't believe that there is a post requirement to upload a file. To upload a file:

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Tutsumi]

Finally got the data I needed. Here's the test example worksheet.

[Fluff13]

How about
=INDEX(Sheet2!$A$1:$A$2,MATCH(E1,Sheet2!$B$1:$B$2,0))

[Tutsumi]

This worked. Thank you!

[Fluff13]

You're welcome & thanks for the feedback