Is there a formula that can find a cell or partial cell in one sheet in the column of another sheet and tell me what the original cell was?
In sheet2, L6 it says "TN880 Bk". It would search column B in Sheet1 and find in B2 "TN880". It would then return the result of "TN880" in M6 (where this formula resides) in sheet2.
Or if it is an exact match it would return the exact match.