Question: vlookup when 2 values are the same?
Answer: To set up a multiple criteria VLOOKUP, follow these 3 steps: Add a helper column and concatenate (join) values from columns you want to use for your criteria. ... For the lookup value, join the same values in the same order to match values in the helper column. Make sure VLOOKUP is set to perform an exact match.