Thread: V Look Up
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RonaldoOneNil RonaldoOneNil is offline
external usenet poster
 
Posts: 117
Default V Look Up

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