i'm trying to write a vlookup that will advise me when a traveller has
visited an airport in belgium..

e.g. the cell will contain something like LHR/CDG/ODL or ODL/LGW/SEA

Basically in the example above I want it to show me when the cell contains
ODL (or another Belgium airport code which i have a list of, hence the
vlookup).

Can this be done, so far I have the following...

=IF(ISERROR(VLOOKUP(C2,'Belgium Codes'!C1:C15,1,0)),"","Belgium")

but this only returns when the cell purely contains "ODL"..

Can anyone help me please?

Thanks,