Match cells

[dbmrexcel1981]

I hope someone can help me please. I have attached an example sheet to this post. Under column B I have a list of customers and under column E I have the same customers but they are in a different order. I have to lift the date beside each customers in column E and place it beside the corresponding customer in column A. I'm currently doing this manually and it's very time consuming. Is there a formula that would quickly do this for me?

Example.xlsx

[FDibbins]

try this, copied down, formatted as date

=VLOOKUP(B2,$E$2:$F$22,2,0)

[stanleydgromjr]

dbmrexcel1981,

The formula in cell C2, formatted as date, copied down:
=VLOOKUP(B2,E:F,2,)

or:
=VLOOKUP(B2,$E$2:$F$22,2,)

[TMS]

Try:

Cell C2:

Please Login or Register  to view this content.

and copy down


Regards, TMS

[TMS]

I'm a little bemused by your sample data. The dates against each customer entry on the right hand side are always the same.

If that's always the case, then use the VLOOKUP that the other guys have suggested. That will always return the first date that it finds for the customer.

If there may be different orders/dates, you might want to use the formula that I have provided. It will return blanks if you have more entries onthe left hand side than the right hand side.

Regards, TMS

[dbmrexcel1981]

Many thanks, all worked cheers!

[FDibbins]

Happy to help and thanks for the feedback

[TMS]

You're welcome. Thanks for the rep.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[stanleydgromjr]

dbmrexcel1981,

You are very welcome. Glad we could help.

Thanks for the feedback.

And, come back anytime.