I have two separate worksheets, and I am trying to create a Vlookup or Index and Match formula. Here is the example:
Cell A1= Employee ID: 123-D.
Vlookup A1 from Sheet 1, and match the first five characters to Column A, Column I and Column P. If a match, return name (e.g. John Doe) in Sheet 1, cell B1.
Thanks so much for your help!!