Forum Discussion
Need to create a formula that uses a key to fill in multiple cells
Sorry if this is super easy, I'm not a big excel user but my boss wants me to do something involving 5000 user names which I don't want to do by hand... Basically I need to fill in the first tabl...
In D2 enter formula:
=INDEX(L:L,MATCH($A2,$K:$K,0))
Drag that formula down for all your rows, and across for all your columns with headers that are now empty.
Kim_Wennerberg Madam, you are GD wizard. Thank you so much!