May 15 2019 01:06 PM
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 table to make it look like the table below it (A23) using the key I made (K1)
Anyone know something I can use for this?
May 15 2019 01:16 PM
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.
May 15 2019 01:34 PM
@Kim_Wennerberg Madam, you are GD wizard. Thank you so much!
May 15 2019 01:47 PM
You are welcome. BTW, not important or relevant, but some people with name of Kim are "sir". That would be me.
That MATCH() function is often part of a rich substitute for the VLOOKUP() function. It will do you well to usuially use INDEX() with MATCH() instead of VLOOKUP(), even though the formula looks intimidating and a bit cryptic. Google search on Excel "MATCH function".