I currently have two lists:
List #1 have the fields country and colour (and several other fields that are irrelevant)
List #2 have the field colour (and several other fields that are irrelevant)
So in List #1, the country Norway might be connected to the colour green.
I want to perform a lookup on List #1 from list #2, so that the country is included with its corresponding colour. This should be possible with the look up function since there is a connection between those two fields.