If you're just looking to show you know how to do things various ways, then use VLOOKUP for some of it, then an INDEX/MATCH for other portions. Both significantly useful tools and showing you can use them should gain you points.

LOOKUP (data needs to be sorted to work properly)
VLOOKUP (data doesn't need to be sorted, but only returns answers to the right of searched range column)
INDEX/MATCH (data doesn't need to be sorted and results can come from left or right of matched column)