VLookup in Quicksight

Hi,
Also have a look at this post as it outlines a similar scenario and solution. Let us know if this helps:

Thanks.