what I need to happen is this: lookup the value in E1P, cell A2, from the list of values in VBAP, A1:A33, then return the exact value from C1:C33 into the E1P table, column 2. What happens now, with the basic vlookup is that the first instance of the 'found' value in VBAP A1:A33 is being returned for each instance. I need the unique values from VBAP c2:c33 to be returned. column C in the E1P tables show what I need returned, but column b is what is being returned.