Consider:
+---------------+
| Column A |
+---+---------------+
| 1 | Milan |
+---+---------------+
| 2 | Paris |
+---+---------------+
| 3 | London |
+---+---------------+
| 4 | Milan |
+---+---------------+
| 5 | Firenza |
+---+---------------+
| 6 | Napoli |
+---+---------------+
| 7 | Amsterdam |
+---+---------------+
| 8 | Copenhagen |
+---+---------------+
| 9 | Amsterdam |
+---+---------------+
Suppose I filter Column A to look for cities in Italy. The following results are returned.
+---------------+
| Column A |
+---+---------------+
| 1 | Milan |
+---+---------------+
| 4 | Milan |
+---+---------------+
| 5 | Firenza |
+---+---------------+
| 6 | Napoli |
+---+---------------+
Now, consider the following expression:
=IFERROR(VLOOKUP($AR5,Copy!$I$1:$K$3,2,0),OFFSET($A$1,2,0))
Does OFFSET
refer to the WHOLE of the source data -- in which case my default value in case of error would be London
-- or only the result set -- in which case my default value in case of error would be Firenze
?
I'm seeing inconsistent results in my worksheet, and what to narrow down my debugging options by undrrstanging what's supposed to happen in this circumtance.