Forum Discussion
Faster way to do this!
I have a set of reoccurring data that has the same letters through out the columns in different orders, and I need to insert names to those reoccurring sets of data. My question is, is there a faster...
Yes, exactly like that. BUT I have over 170 different names in that A Column, and over 1000 rows that need to be filled. That was a short example of what I am trying to do.
I have about 25 Names and those names go to a specific 3 letter code (there are about 170 different 3 letter codes) , and I have about 1000 of those 3 letter codes those names belong to.
Would I have to have a really long formula to execute this? Fortijo
Have a look at the vlookup function.