Loop to set 250 strings to cell contents

[snb]

or

Sub M_snb()
    [a2:IP2] = [index("snb_"&A1:IP1,)]
End Sub