Forum Discussion

A2Z CF's avatar
A2Z CF
Brass Contributor
Jul 13, 2022
Solved

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. Al...
excel
  • OliverScheurich's avatar
    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.
     

OliverScheurich's avatar
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's avatar
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

Resources