Stumped

[doncornerstone]

How do you auto populate when it is not a fully numerical number?

A-01-01

A-02-01

A-03-01

A-04-01

...to A-38-01

Would appreciate any help.

[#2]

@doncornerstone 

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.

[#3]

@doncornerstone 

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")

[#4]

Appreciate the help, I'll look into this after the holiday.

Thanks again!

[#5]

@Sergei Baklan 

Appreciate the help, I'll look into this after the holiday.

Thanks again!