Data searching and placement

Hello everybody,

I have two random names list in Column-C and Column-J and three blank Columns as F, G and H. The complete list of names including their relevant data is in Columns J, K, L and M. All I want is that data to be placed on Column F, G and H upon matching names in Column-C with Column-J. Any help in form of Macro or formula will greatly appreciated and thank you in advance.

excel

OliverScheurich
Jul 13, 2022
A2Z CF
=INDEX(K$2:K$22,MATCH($C2,$J$2:$J$22,0))
An alternative could be INDEX and MATCH.

4 Replies

OliverScheurich
Gold Contributor
Jul 13, 2022
A2Z CF
=INDEX(K$2:K$22,MATCH($C2,$J$2:$J$22,0))
An alternative could be INDEX and MATCH.
- A2Z CF
  Brass Contributor
  Jul 14, 2022
  Awesome! Thank you so much for providing solution for a very complex problem. It works really great! I appreciate it very much. Thanks once again
Riny_van_Eekelen
Platinum Contributor
Jul 13, 2022
A2Z CF Depending on your Excel version, look into VLOOKUP or XLOOKUP. Many examples are found on line. No VBA needed.
- A2Z CF
  Brass Contributor
  Jul 14, 2022
  Thank you so much for the long-term solution. I appreciate it very much
  Thank you again

Forum Discussion

Data searching and placement

4 Replies

Resources