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.
     

Riny_van_Eekelen's avatar
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's avatar
A2Z CF
Brass Contributor
Jul 14, 2022
Thank you so much for the long-term solution. I appreciate it very much
Thank you again

Resources