Vlookup with If statement or matching index with If statement

[Bwalsh]

I’m trying to do something that I thought would be relatively simple but turns out to be more complicated than I thought and I am stuck. I have two sheets with data and need to do the following:

Look up an email address located in sheet one (column E), find the email in the second sheet (column D) and then if the customer number in the first sheet (column f) equals the customer number in the second sheet (column E) I then need it to return the information in Column F (order filled) of the second sheet.

I tried to do a vlookup with the if function and tried index matching but neither returned any values.


I’m working with Excel 2016. Any help or suggestions would be most appreciated. Thank you!

 

[AhoyNC]

the MATCH check formula I posted above is an array formula and must be entered with CTRL-SHIFT-ENTER.

 

[philwojo]

Also, what are you getting, an error or does it appear nothing is happening? Do you have automatic calculations turned off? you can always try and hit F9 to cause calculations to take place and see if it updates. Providing more specific information on what the issue you are seeing is better than a generic description of it isn't working.

 

[Bwalsh]

I am getting actual matches for some. thanks for your help!