determine which column has a value

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I am using =MATCH("Totals",B1:AZ1,0) to tell me which column 'totals'
is in. However, the result is an integer and I would like to use this
column in a range("x:x+3") statement.

How can I calculate the above and be able to use the results in a
range() statement?

Ultimately, I want to be able to do this:
If Not Intersect(target, Range("B:J")) Is Nothing Then target.Offset(0,
11).Select
with a variable range of columns.

Thanks.

.