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...
Can you post a sample workbook please?
Sorry for the late reply about this. Those letters to the left (THO, SHH, etc) I have, but how do I add the ones to the right much easier(West, Loan, Super, etc)? Instead of having to manually add those in there one by one and dragging them down. I have over 1000 rows of this.
jrramz22 Can you please upload a (sanitized) copy of your file with just the long list of codes and the list of 25 names and their codes? I'm sure this requires a simple VLOOKUP rather than the complicated 25-level nested IF formula.
