Can be simplified a bit to:

=VLOOKUP(AA15,IF(AA5="Category Data",'Category Data'!B:G,'Unilever Data'!B:G),6,FALSE))