There is nothing wrong with the formula, but without knowing what is in A2
and what is in your range A3:J763 and with your description 'Can't get the
thing to work' we cannot help further.
Check that the contents of cell A2 exists in column A on your Cognos sheet.

"tonyagrey" wrote:

WHats wrong with this formaula? Cant get the thing to work

=VLOOKUP(A2,Cognos!$A$3:$J$763,2,FALSE)
--
Tony