Vlookup

[Buxton]

Question
When doing a v'lookup do the lookup value and the table of array must be
the
same format? see example below
example 000102025 table of array 102025 the zero was converted as text
would that affect my results.

Look up value table array column index range lookup
=Vlookup('fcapdata'!a:A,summer!$A:$GF,12False) why when I copied this
formula it still refers me to the previous worksheet that was used and when I
tried to edit the link it is giving me an error message.

 

[Pete_UK]

Yes, there has to be an exact match in values, although if you always
have three leading zeros you can do it this way:

=VLOOKUP("000"&'fcapdata'!A1,summer!$A:$GF,12,FALSE)

fcapdata and summer are refering to other sheets, but if fcapdata is
the sheet where your formula resides you can omit it.

Hope this helps.

Pete