Dec 23 2020 01:40 PM
In this case you can combine ROW and COLUMN functions to convert its placement to a number while using CONCATENATE to tie them together. I added a letter next to the corresponding table to make the lookup more dynamic, you can hide it by converting the font to White.
Dec 23 2020 01:45 PM
Depends on which version of Excel you are. Variants
="A-" & TEXT(ROW()-ROW($B$2),"00")&"-"&TEXT(COLUMN()-COLUMN($B$2)+1,"00")
or
="B-"&TEXT(INT((SEQUENCE(38,5)-1)/5)+1,"00")&"-"&TEXT(MOD(SEQUENCE(38,5)-1,5)+1,"00")
Dec 23 2020 02:03 PM
Appreciate the help, I'll look into this after the holiday.
Thanks again!
Dec 23 2020 02:03 PM