i have changed my formula slightly as suggested, but the error remains and it
says that the "'[copy" section in the col_index_num is the problem. i want
the returned value to be the corresponding cell in the third column and that
is part of the name of the file to find the 3rd column. not sure if that
makes sense, confusing myself really.
Any further suggestions?
Many Thanks

"Franz" wrote:

"Micayla Bergen" ha scritto nel
messaggio

i have this formula for vlookup but i get an error for returning the
3rd column value in copy2share workbook/
=VLOOKUP(A4,'[copy 2Share Recommendations.xls]Stocks:Property &
Infrastructure'!B10:B320,'[copy 2Share
Recommendations.xls]Stocks:Property & Infrastructure'!B10:B320, 3)


Which kind of error? Maybe you forget to add FALSE as the fourth argument in
the function; try this:

=VLOOKUP(A4,'[copy 2Share Recommendations.xls]Stocks:Property &
Infrastructure'!B10:B320,'[copy 2Share
Recommendations.xls]Stocks:Property & Infrastructure'!B10:B320, 3,FALSE)

--
Hoping to be helpful...

Regards

Franz

----------------------------------------------------------------------------------------
To reply translate from italian InVento (no capital letters)
----------------------------------------------------------------------------------------