Hey!
This is my first time posting here so I hope I'm in the right area. My problem is like this:
I have a list of sentences that contain a car licence plate number in, say, column A. Then i have a list of the licence plates in column C and in column D the car stock number. For example in C1 the plate ABC-123 and in D1 the number 1, C2 ABC-124 and D2 the number 2 etc.
What I would need excel to help me with, is when I copy/paste a new list of sentences in column A, it would return me the stock number of the car in column B by finding it in columns C and D. How can this be done?
Thank you a lot!
Bookmarks