others:

=VLOOKUP(INDEX(AQ:AQ,ROW()),sym,(COLUMN(CD212)-COLUMN(AQ212))+1,FALSE)

=VLOOKUP(INDEX(A:A,ROW()),EE_Data,2,FALSE)

=VLOOKUP(AQ360,[sym.xls]sym!$AQ$100:$CD$4000,(COLUMN(CD212)-COLUMN(AQ212))+1,FALSE))



"chrishka" wrote:

I am trying to do a simple VLOOKUP formula which i have done hundreds of
times before ,but when i do the formula the only reslut in that cell is the
vlookup formula itself. it is as if I have written text into that cell and
not a formula even though it start with an =. i have tried changing the
format of the cell , but nothing seems to work

please help