I have copied my vlookup formula across 25 columns and need to reference 25
columns on a data tab. My first formula is:
=vlookup($C20,'data$A$1:$a$50',2,false).... I need to changed the column
lookup for the remaining 24 columns to =vlookup(.....,3,false)
=vlookup(.....,4,false) and so on.

Is there a faster way to change the columns #'s rather than manually
changing them?

thank you in advance! jane