If your values are digits, then it's not enough to just change the format of the
cell. You'll have to change the entry, too.

There are ways of doing that, but you'll have to share more info.

tonyagrey wrote:

1. Currently returning #NA
2. A2 is definitely available i have manually checked it.
3. I have formatted the text in both sheets so that they are the same .

Still no luck. Any other suggestions?
--
Tony

"Jacob Skaria" wrote:

You formula is correct.

1. Currently what does that return...

2. Check whether A2 is available in A3:A763. If so check whether it is
spelled exactly same as that of cell A2. (without any extra spaces)

3. If A2 is not found the formula returns #NA error. If you are looking to
handle this then use ISNA() with IF() to handle this as below ...
=IF(ISNA(VLOOKUP(A2,Cognos!$A$3:$J$763,2,0)),"",
VLOOKUP(A2,Cognos!$A$3:$J$763,2,FALSE))

--
Jacob (MVP - Excel)


"tonyagrey" wrote:

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

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

--

Dave Peterson