Comparing columns, need to quickly change what cols being compared
 

Comparing 2017 rate to 2018
Trying to make process quick and simple

3 sheets
2017
2018
Compare

Yearly sheets are identical in format, one column per customer, various services listed down col A, only difference is the rates for each year.

In COMPARE tab, Col B maps to 2017 customer, col C to same customer in col C. I currently change cell B1 and C1 to match customer column I need and just copy down.

I want to make it a bit more sexy.
Enter in a cell the column from 2017 that I want and a cell that ref col in 2018.
Or enter a customer name for each year and it populates each column.

TIA

Jerry

indirect
 

Resolved

Used indirect function, which I had never knew about