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...
Kim_Wennerberg Madam, you are GD wizard. Thank you so much!
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".