I have a very large Google Sheet spreadsheet that I need help with.

I have a long list of Network Switches that are very often repeated that I am trying to automatically copy the associated SKU into a separate adjacent cell.

My goal was, once the SKU is added the first time, whenever the same switch is added again, it will autopopulate with the same SKU.

For instance, C2461:C2463 are repeated, and once K2461 is populated, would like K2462 & K2463 to follow suit.

Any help would be greatly appreciated!

CodePudding user response：

You can try this formula on Column L (col L will serve as a helper column):

=iferror(arrayformula(VLOOKUP(C2:C,C2:K,9,False)),"")

For now I can't seem to fit the formula without the use of a helper column (so I created a separate sheet for now that will serve as a database for the VLOOKUP formula) but this should get you started.

Sample using a helper spreadsheet (Database):

=iferror(arrayformula(VLOOKUP(Database!A2:A,Database!A2:B,2,False)),"")

Output: