| I have Two Data Sheets"Sheet 1 (Raw Departures)" and "Sheet 2 (Raw Arrivals)" | |||||||||
| Sheet 1 (Raw Departures) | Sheet 2 (Raw Arrivals) | ||||||||
| Guest | Site# | Guest Name | Site# | Match Site Row #. Sheet 1 | |||||
| Rrookie, Dan | 3 | Bell, Michael Steven | 74 | n/a | |||||
| Criss, Leon | 5 | Brown, Beth | 18 | n/a | |||||
| David, Clyde | 129 | Brown, Greg | 64 | n/a | |||||
| Evant, Tim | 64 | Celino, Darrell | 153 | n/a | |||||
| Smith, Jack | 63 | Cordova, Edgar | 124 | n/a | |||||
| Ham, Steve | 151 | Land, Danica | 37 | 20 | Site Does not Match | ||||
| Hakins, Sam | 39 | David, Clyde | 129 | 13 | Matched Site# | ||||
| Hookins, Shilo | 18 | Davis, Tina | 107 | n/a | |||||
| Kesslerl, Mikdew | 131 | Evant, Tim | 121 | 14 | Matched Site# | ||||
| Land, Danica | 133 | Hookins, Shilo | 18 | 18 | Matched Site# | ||||
| Using a Match() formula I have detected that "David, Clyde | |||||||||
| s in both sheets and the site number on Sheet 1 is in row 13. | |||||||||
| I now need to know if the site number is the same for both sheets; | |||||||||
| if "True" populate G12 with "Extended Stay" | |||||||||
| IF "FALSE" populate G12 with " Moved to New Site" | |||||||||
| How can I dynamically change the row # in a formula? | |||||||||
| Something like | |||||||||
| "= If("Sheet 1" Column B, row# (based on G"X","Extended Stay","Moved to New Site"" | |||||||||
| I need to change the row# based on the Row found in the Match() | |||||||||
| Any help is appreciated. |
Updated Mar 16, 2024
Version 3.0