M
mozza820
Hi guys,
Basically it is a simple problem but no one knows a simple solution. I
am using VLOOKUP to find values fronm a table with about 40 columns,
but sadly I am not in control of this table and the columns order can
change (ie A becomes C and D becomes B) but I dont want to re-write the
code evrytime the column changes. So basically I need a way of using
VLOOKUP but not entering the column number and entering the column name
so it searches for that. So for example, it will look for the column
entitled 'Username' and not just the '7th column in' for example, as in
a few mnths tim,e it will still be called 'Username' but may now be the
9th column in.
Any help is appreciated. Thanks.
Basically it is a simple problem but no one knows a simple solution. I
am using VLOOKUP to find values fronm a table with about 40 columns,
but sadly I am not in control of this table and the columns order can
change (ie A becomes C and D becomes B) but I dont want to re-write the
code evrytime the column changes. So basically I need a way of using
VLOOKUP but not entering the column number and entering the column name
so it searches for that. So for example, it will look for the column
entitled 'Username' and not just the '7th column in' for example, as in
a few mnths tim,e it will still be called 'Username' but may now be the
9th column in.
Any help is appreciated. Thanks.