Excel - Reference Data only once that appears multiple times

Vote count:

0

An example of what I am trying to accomplish here: http://ift.tt/1mQHPd1

Goal: Create a formula that automatically fills in the State cells (Column B, Sheet1) based on transaction data from Sheet 2.

On sheet1, each city is only listed once as it's aggregate data, but on Sheet2, each city/state could be listed multiple times as there are multiple transactions.

Note @ Mods: Please keep this tagged as "Excel" even though I'm sharing a Google Doc. I need to know how to do this in both Excel and Google Spreadsheets, but don't know how to share an online excel sheet. Thanks.

asked 15 secs ago

user2705241

13