Spreadsheet: 755859d1637148272-find-in-replace-with-x-if-value-is-y-y-and-x-is-on-a-list-replacement
Sheet: Sheet1

Raw Data |  |  |  |  |  |  |  |  | Replacement list |  |  |  |  | Desired result
Site | Hours | Rate |  |  |  |  |  |  | Data Site | Correction |  |  |  | Site | Hours | Rate
[NAME] | 8 | 10 |  |  |  |  |  |  | [NAME] | Chicago |  |  |  | Chicago | 8 | 10
London | 8 | 10 |  |  |  |  |  |  | Amster | Amsterdam |  |  |  | London | 8 | 10
Dublin | 6 | 11.5 |  |  |  |  |  |  | SanDie | San Diego |  |  |  | Dublin | 6 | 11.5
Amster | 8 | 12 |  |  |  |  |  |  | Orland | Orlando |  |  |  | Amsterdam | 8 | 12
SanDie | 4 | 14.5 |  |  |  |  |  |  | Mexico | Mexico City |  |  |  | San Diego | 4 | 14.5
Orland | 3 | 21 |  |  |  |  |  |  | Atlant | Atlanta |  |  |  | Orlando | 3 | 21
Mexico | 7.5 | 8 |  |  |  |  |  |  | HongKo | Hong Kong |  |  |  | Mexico City | 7.5 | 8
Atlant | 8 | 25 |  |  |  |  |  |  | Sigap | Singapore |  |  |  | Atlanta | 8 | 25
HongKo | 9 | 12.5 |  |  |  |  |  |  | NewYor | New York City |  |  |  | Hong Kong | 9 | 12.5
Sigap | 8 | 12.5 |  |  |  |  |  |  | LosAng | Los Angeles |  |  |  | Singapore | 8 | 12.5
Beijin | 7 | 10 |  |  |  |  |  |  | OsakaK | Osaka-Kobe |  |  |  | Beijing | 7 | 10
Dubai | 6 | 10 |  |  |  |  |  |  | Toront | Toronto |  |  |  | Dubai | 6 | 10
NewYor | 6 | 11.5 |  |  |  |  |  |  | [NAME] | Shanghai |  |  |  | New York City | 6 | 11.5
LosAng | 4 | 12 |  |  |  |  |  |  | Parsi | Paris | (note, correction due to spelling error) |  |  | Los Angeles | 4 | 12
OsakaK | 7 | 14.5 |  |  |  |  |  |  | SanFra | San Francisco |  |  |  | Osaka-Kobe | 7 | 14.5
Toront | 7 | 21 |  |  |  |  |  |  | SanJos | San Jose |  |  |  | Toronto | 7 | 21
[NAME] | 6 | 8 |  |  |  |  |  |  | Seattl | Seattle |  |  |  | Shanghai | 6 | 8
Parsi | 8 | 25 |  |  |  |  |  |  | Melbou | Melbourne |  |  |  | Paris | 8 | 25
Seoul | 8 | 12.5 |  |  |  |  |  |  | Barcel | Barcelona |  |  |  | Seoul | 8 | 12.5
Boston | 8 | 12.5 |  |  |  |  |  |  | Bangko | Bangkok |  |  |  | Boston | 8 | 12.5
SanFra | 6 | 10 |  |  |  |  |  |  | Honol | Honolulu |  |  |  | San Francisco | 6 | 10
SanJos | 8 | 10 |  |  |  |  |  |  | Istan | Istanbul |  |  |  | San Jose | 8 | 10
Seattl | 4 | 11.5 |  |  |  |  |  |  | Helsin | Helsinki |  |  |  | Seattle | 4 | 11.5
Melbou | 3 | 12 |  |  |  |  |  |  | Lasveg | Las Vegas |  |  |  | Melbourne | 3 | 12
Barcel | 7.5 | 14.5 |  |  |  |  |  |  | Jerusa | Jerusalem |  |  |  | Barcelona | 7.5 | 14.5
Bangko | 8 | 21 |  |  |  |  |  |  | CapeT | Cape Town |  |  |  | Bangkok | 8 | 21
Honol | 9 | 8 |  |  |  |  |  |  | [NAME] | [NAME] |  |  |  | Honolulu | 9 | 8
Istan | 8 | 25 |  |  |  |  |  |  | Casabl | Casablanca |  |  |  | Istanbul | 8 | 25
Helsin | 7 | 12.5 |  |  |  |  |  |  | [NAME] | [NAME] |  |  |  | Helsinki | 7 | 12.5
Lasveg | 6 | 12.5 |  |  |  |  |  |  | Edinbu | Edinburgh |  |  |  | Las Vegas | 6 | 12.5
Jerusa | 6 | 10 |  |  |  |  |  |  | Copenh | Copenhagen |  |  |  | Jerusalem | 6 | 10
CapeT | 4 | 10 |  |  |  |  |  |  | Auckla | Auckland |  |  |  | Cape Town | 4 | 10
[NAME] | 7 | 11.5 |  |  |  |  |  |  | St.Cha | St. Charles |  |  |  | [NAME] | 7 | 11.5
Casabl | 7 | 12 |  |  |  |  |  |  |  |  |  |  |  | Casablanca | 7 | 12
[NAME] | 6 | 14.5 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 6 | 14.5
Edinbu | 8 | 21 |  |  |  |  |  |  |  |  |  |  |  | Edinburgh | 8 | 21
OsakaK | 8 | 8 |  |  |  |  |  |  |  |  |  |  |  | OsakaK | 8 | 8
Copenh | 8 | 25 |  |  |  |  |  |  |  |  |  |  |  | Copenhagen | 8 | 25
Lima | 6 | 12.5 |  |  |  |  |  |  |  |  |  |  |  | Lima | 6 | 12.5
Auckla | 8 | 12.5 |  |  |  |  |  |  |  |  |  |  |  | Auckland | 8 | 12.5
Mumbai | 4 | 10 |  |  |  |  |  |  |  |  |  |  |  | Mumbai | 4 | 10
Dubai | 3 | 10 |  |  |  |  |  |  |  |  |  |  |  | Dubai | 3 | 10
Munich | 7.5 | 11.5 |  |  |  |  |  |  |  |  |  |  |  | Munich | 7.5 | 11.5
Qatar | 8 | 12 |  |  |  |  |  |  |  |  |  |  |  | Qatar | 8 | 12
Zion | 9 | 14.5 |  |  |  |  |  |  |  |  |  |  |  | Zion | 9 | 14.5
St.Cha | 8 | 21 |  |  |  |  |  |  |  |  |  |  |  | St. Charles | 8 | 21
[NAME] | 7 | 8 |  |  |  |  |  |  |  |  |  |  |  | Chicago | 7 | 8
London | 6 | 25 |  |  |  |  |  |  |  |  |  |  |  | London | 6 | 25
Dublin | 6 | 12.5 |  |  |  |  |  |  |  |  |  |  |  | Dublin | 6 | 12.5
Amster | 4 | 12.5 |  |  |  |  |  |  |  |  |  |  |  | Amsterdam | 4 | 12.5
SanDie | 7 | 10 |  |  |  |  |  |  |  |  |  |  |  | San Diego | 7 | 10
Orland | 7 | 10 |  |  |  |  |  |  |  |  |  |  |  | Orlando | 7 | 10
Mexico | 6 | 11.5 |  |  |  |  |  |  |  |  |  |  |  | Mexico City | 6 | 11.5
Atlant | 8 | 12 |  |  |  |  |  |  |  |  |  |  |  | Atlanta | 8 | 12
HongKo | 8 | 14.5 |  |  |  |  |  |  |  |  |  |  |  | Hong Kong | 8 | 14.5
Sigap | 8 | 21 |  |  |  |  |  |  |  |  |  |  |  | Singapore | 8 | 21
Beijin | 6 | 8 |  |  |  |  |  |  |  |  |  |  |  | Beijing | 6 | 8
Dubai | 8 | 25 |  |  |  |  |  |  |  |  |  |  |  | Dubai | 8 | 25
NewYor | 4 | 12.5 |  |  |  |  |  |  |  |  |  |  |  | New York City | 4 | 12.5
LosAng | 3 | 12.5 |  |  |  |  |  |  |  |  |  |  |  | Los Angeles | 3 | 12.5
OsakaK | 7.5 | 10 |  |  |  |  |  |  |  |  |  |  |  | Osaka-Kobe | 7.5 | 10
Toront | 8 | 10 |  |  |  |  |  |  |  |  |  |  |  | Toronto | 8 | 10
[NAME] | 9 | 11.5 |  |  |  |  |  |  |  |  |  |  |  | Shanghai | 9 | 11.5
Parsi | 8 | 12 |  |  |  |  |  |  |  |  |  |  |  | Paris | 8 | 12
Seoul | 7 | 14.5 |  |  |  |  |  |  |  |  |  |  |  | Seoul | 7 | 14.5
Boston | 6 | 21 |  |  |  |  |  |  |  |  |  |  |  | Boston | 6 | 21
SanFra | 6 | 8 |  |  |  |  |  |  |  |  |  |  |  | San Francisco | 6 | 8
SanJos | 4 | 25 |  |  |  |  |  |  |  |  |  |  |  | San Jose | 4 | 25
Seattl | 7 | 12.5 |  |  |  |  |  |  |  |  |  |  |  | Seattle | 7 | 12.5
Melbou | 7 | 12.5 |  |  |  |  |  |  |  |  |  |  |  | Melbourne | 7 | 12.5
Barcel | 6 | 10 |  |  |  |  |  |  |  |  |  |  |  | Barcelona | 6 | 10
Bangko | 8 | 10 |  |  |  |  |  |  |  |  |  |  |  | Bangkok | 8 | 10
Honol | 8 | 11.5 |  |  |  |  |  |  |  |  |  |  |  | Honolulu | 8 | 11.5
Istan | 8 | 12 |  |  |  |  |  |  |  |  |  |  |  | Istanbul | 8 | 12
Helsin | 6 | 14.5 |  |  |  |  |  |  |  |  |  |  |  | Helsinki | 6 | 14.5
Lasveg | 8 | 21 |  |  |  |  |  |  |  |  |  |  |  | Las Vegas | 8 | 21
Jerusa | 4 | 8 |  |  |  |  |  |  |  |  |  |  |  | Jerusalem | 4 | 8
CapeT | 3 | 25 |  |  |  |  |  |  |  |  |  |  |  | Cape Town | 3 | 25
[NAME] | 7.5 | 12.5 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 7.5 | 12.5
Casabl | 8 | 12.5 |  |  |  |  |  |  |  |  |  |  |  | Casablanca | 8 | 12.5
[NAME] | 9 | 10 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 9 | 10
Edinbu | 8 | 10 |  |  |  |  |  |  |  |  |  |  |  | Edinburgh | 8 | 10
OsakaK | 7 | 11.5 |  |  |  |  |  |  |  |  |  |  |  | OsakaK | 7 | 11.5
Copenh | 6 | 12 |  |  |  |  |  |  |  |  |  |  |  | Copenhagen | 6 | 12
Lima | 6 | 14.5 |  |  |  |  |  |  |  |  |  |  |  | Lima | 6 | 14.5
Auckla | 4 | 21 |  |  |  |  |  |  |  |  |  |  |  | Auckland | 4 | 21
Mumbai | 7 | 8 |  |  |  |  |  |  |  |  |  |  |  | Mumbai | 7 | 8
Dubai | 7 | 25 |  |  |  |  |  |  |  |  |  |  |  | Dubai | 7 | 25
Munich | 6 | 12.5 |  |  |  |  |  |  |  |  |  |  |  | Munich | 6 | 12.5
Qatar | 8 | 12.5 |  |  |  |  |  |  |  |  |  |  |  | Qatar | 8 | 12.5
Zion | 8 | 10 |  |  |  |  |  |  |  |  |  |  |  | Zion | 8 | 10
St.Cha | 8 | 10 |  |  |  |  |  |  |  |  |  |  |  | St. Charles | 8 | 10