Insert value based on another column in different sheet

[Rick187]

Hi,

I have a list of email addresses in a spreadsheet. I have another sheet in the same excel with a Pivot that allows me to filter based on city. For example if I filter the city by "Amsterdam" I can see all the email addresses in "Amsterdam".

In the main spreadsheet with all the email addresses, I have added a column called Country. I would like the word "Netherlands" to be added in the cell for the country column next to each email address that is from "Amsterdam" from the pivot sheet.

Does anyone know the best formula for doing this please?

Any help would be appreciated.

Thanks in advance.

 

[nc_waggoner]

It would be helpful to see how this workbook is set up. What data set is the pivot based on for example?