Please can anyone tell me if there is a version of the VLOOKUP which will return all matches, and not just the first one.
For example, please see the attachment.
The second sheet ('Cities') has a list of countries and cities.
The first sheet ('Country') contains the VLOOKUP function, but it will only return the first match it finds.
What function do i need to use so that what is returned is EVERY match.
e.g. If I enter 'Italy' , I want it to return 'Rome' and 'Venice' (either in adjacent cells in the same row, or in the same cell, for example).