I am trying to find part of text in one cell and if found return the text in another cell. For example, cell A1 contains text ddd R8923-01 rev.2, cell D1 contains part of that text: R8923. If cell D1 contains part of cell A1 (which it does) I want to return the value in cell E1 which is "book" on another worksheet. I'd imagine it's a lookup of some kind but can't quite figure it out. Can you please help?
Solved by S. J. in 18 mins