Vlook up

[malisa01]

I've done a very simple formula using VLookup. Iget #NA. I know the formula is correct.
=IF(A3,' 2011 HIMSS Analytics'!B3,FALSE)

I think the problem is because I exported the information and excel is not reading the #'s correctly because of the original file typ?? Any help is apreciated!

lisa

 

[Aladin Akyurek]

It doesn't work. ugh, I feel like it is a behind the seen problem with the file. But it seems like I have it all the time???? So frustating. It is a very simple formula, ugh!

I don't know why I have a space in the tab name??? Do you think that is the problem. I've had spaces before.

Lisa

Space is unnecessary, but not the problem you have.

However, what did...

=IF(ISNUMBER(SEARCH(A15,' 2011 HIMSS Analytics'!$B$3)),' 2011 HIMSS Analytics'!$C$3),"Not Found")

yield?

 

[malisa01]

It said there was an error in the formula.

 

[Aladin Akyurek]

It said there was an error in the formula.

Yeah, it should be:

=IF(ISNUMBER(SEARCH(A15,' 2011 HIMSS Analytics'!$B$3)),' 2011 HIMSS Analytics'!$C$3,"Not Found")

And, what result do we get?

 

[malisa01]

This time I didn't get an error it gave me "Not Found" but the problem is, the information is there. That is one of the problems with the Vlook up. It was giving me the wrong information.???

 

[Aladin Akyurek]

This time I didn't get an error it gave me "Not Found" but the problem is, the information is there. That is one of the problems with the Vlook up. It was giving me the wrong information.???

What is in A15? And what is in ' 2011 HIMSS Analytics'!$B$3 when you get Not Found as result?

 

[vinx98]

Hi, the cells you are comparing, make sure they are both formatted as numbers. right click format cells numbers.

 

[malisa01]

I did, it's till not working. I'm signing off. Thanks!