A bit more detail

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jennifer" wrote in message
...
I currently use VLookup on a few worksheets to get data from another
worksheet. I don't use the same formula for each worksheet though because
they represent a different company and thus a different column from the
other
sheet (the one I'm getting data from). Is there anyway to instead of
using a
number for the column VLookup is searching in to use a name?

I ask this because the column numbers will more than likely change (and I
have no control over this). However, the names remain the same.