Hello Everyone,
I have I list of unique identifiers in one worksheet. I would like to look up those identifiers in a separate sheet but the unique identifiers have suffixes. These are text unique identifiers. The Unique ID is six digits.
When it has found the relevant data in the separate sheet, it needs to return the NINE cells to the right.
I tried index and Match but it didn't seem to work.
Can anyone help?
Thanks
L
Bookmarks