Questions Row set using column set in formula

if I have column set for current year column and last year column

I can show information from column by referencing column letter and row code

but if I have multiple columns for different outlets it is same number accross

I am trying to write formula that would say if this is column B find column c row code, if its column d find column E row code ..but it doesn't work, ... does anyone know how this can be done

Thanks