Thanks Carlos I thought this may be the case.
"Carlos Antenna" wrote:
The lookup value must be in the first column of the range.
From help on vlookup:
Syntax
VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup)
Lookup_value is the value to be found in the first column of the array.
Lookup_value can be a value, a reference, or a text string.
--
Carlos
"Steved" wrote in message
...
Hello From Steved
trying to lookup values in column F instead of A?
What I done was to insert a column in A then copied the F Col to check to
see if the formula would work and it does now i've put the information
back
in Column F.
"C01d" wrote:
Could you provide more information on your problem? Are you trying to
copy the formula from column A to F or trying to lookup values in
column F instead of A?
--
C01d
------------------------------------------------------------------------
C01d's Profile:
http://www.excelforum.com/member.php...o&userid=34422
View this thread:
http://www.excelforum.com/showthread...hreadid=546582