Roses8 said:Hi, Im trying to do a vlookp but with wrong results.
look up the value in B2 and match in column B in sheet 2, if they match then take the name from Column A in the same row should be the result.
=VLOOKUP(B2,Sheet2!A:B,2,1)
Thanks.