We can use the Match function along with Vlookup to pick up the multiple values from the multiple columns in the worksheet. You can use in many variations.
