Hi Guys,
I am struggling to get a result from matching a cell. I have attached an example as it is hard to explain. I want to display the result in Column H, so I need a calculation to find the value in cell F5 within column B and display the value in D if found. Column F can change value though. so my first result in cell H5 would display 0020 - D D H Double Hanging Robe.
I hope I have explained it ok.
Thanks
Bookmarks