I have 2 spreadsheets. In the first is 2 columns ID and Name. The ID column being blank. The same Name is listed several times in the rows. e.g. ID / Name / A / A / A / A / B / B / C In the 2nd sheet I have 2 columns ID and Name. Both fields are filled out but name is only listed 1x. What's the best way to use an Excel formula to show the ID multiply times next to a name in sheet 1? I used the VLOOKUP formula for a different sheet, but it's not working for this. Any ideas?