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
Bookmarks