I have Sheet2 with the value of the Name list, each name has 2 values for Type A and Type B. I'd to find the value of Type A and Type B for each Name on Sheet 1. If I use VLOOKUP, I can only find 1 value of Type A. Please help.