Hi, On one tab the cell contains a text string that includes the unique id number is within quotes (i.e. Employee number "12345" failed skills test). On another tab there is a listing of all employee numbers in one column with first and last names in separate columns. Can a Vlookup search the text for the first set of quotes, and match it to information on the second tab?

Tab 1
Column A, cell 2
Employee number "12345" belongs to department 19.

Tab 2
Column A, cell 2
12345
Column B, cell 2
Lname
Column C, cell 2
Fname
Column D, cell 2
Location