Hi all

I am trying to find an excel function that allows me to search for a cell value in column of values in a different workbook. It should be able to match against part of the string in the different workbook and then return the full value of that cell. I can use control+F which finds these values within the string on the other workbook however there are 5k records so its too manual

These are the cell values that I wish to look up

Codes to Look Up.png

This is the column where the look up table is held

Look Up Column.png

This shows the results that I would expect to see:

Expected Results.png

Any help would be greatly appreciated!

thanks a lot

James