2 criteria Vlookup from 1st sheet to 2nd sheet

[AaruJaan]

Hi Experts,

I have 2 sheets file, in first sheet email missing, I want to collect emails from the second sheet by 2 criteria Phone# and City.

please see the screenshots:

Thanks in advance

[Pete_UK]

It would help if you attached a sample Excel workbook, as no-one would relish typing in your data before being able to work on a potential solution.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Please note that the Paperclip icon (Attachments button) does not work.

Hope this helps.

Pete

[MarvinP]

Hi,

You only need to do a Vlookup (or Index Match) on the phone number. You don't need the city included (unless two phone numbers from different cities are the same) in the lookup.

Attach a sample of the workbook and we can do the formula for you.


Attach a sample workbook. 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.

[AaruJaan]

this is the example file.

[AaruJaan]

1st sheet actual data and 2nd sheet for email collecting

[MarvinP]

Here you go...

Index Match for Phone Numbers.xlsx

[AaruJaan]

Thanks Marvin