Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

My colleague asked me how to implement a VLOOKUP formula because he was getting an #N/A error message. I highlighted the cells but I did not receive a tooltip like the one shown in the image below (couldn't post image because reputation is too low). I tried to fix the problem by changing the format of the cells (right click, Format Cells...) being referenced by the formula but I couldn't get it to work. I had him email me the file and then I opened it on my computer and when I highlighted the cells in question the tooltip appeared. Is there some kind of Excel configuration that determines if this tooltip appears? (I might be misusing the word tooltip, I mean that yellow box with the ! in it. Thank you for your help.

share|improve this question

migrated from Feb 22 '13 at 20:14

This question came from our site for professional and enthusiast programmers.

up vote 3 down vote accepted

Excel sees the values in column P as text strings. My guess is your VLOOKUP reference are numbers. Change your formula from ...VLOOKUP(P2... to ...VLOOKUP(VALUE(P2)...

share|improve this answer
Someone give me rep so I can upvote this guy's answer. – Richard Pullman Feb 22 '13 at 17:05
Thank you ExactaBox who you have in the 5th race at Belmont tomorrow? – Richard Pullman Feb 22 '13 at 17:05
@RichardPullman you'll be able to upvote as soon as you have 15 rep. just one more nice question or answer - and you're done. Good luck!) – Peter L. Feb 22 '13 at 18:21

You can just add a column with the formula "=1*A2" where A2 is the cell which contains the number formatted as text.

share|improve this answer
This Also works! – Richard Pullman Feb 22 '13 at 17:32

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.