How to find a cell from a range and identify its column number

I want to be able to locate a cell within a range eg "Year" and identify which column it is in, and then assign that column number to a variable?

Any Ideas?

ie range is A1:A10

try this (array formula)

{=ADDRESS(MIN(IF($A$1:$A$10="year";ROW($A$1:$A$10)));MIN(IF($A$1:$A$10="year";COLUMN($A$1:$A$10)));4)}

sorry meant to say in VBA