When using Vlookup in Excel and the formatting of the cell I...

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

<< Back to general questions

[ Home | FAQ-Related Q&As | General Q&As | Answered Questions ]

Question by Pink Panther
Submitted on 4/15/2004
Related FAQ: N/A
Rating:	Rate this question:
When using Vlookup in Excel and the formatting of the cell I am linking to is not exactly the same, the data shows as N/A. To correct his I can format the cell with the same format, hit the F2 key, and then enter and the data shows properly. How can I do this for a range of cells without having to F2 and "enter" on each individual cell?

Answer by westie91
Submitted on 7/9/2004
Rating:	Rate this answer:
Everytime I do a VLOOKUP, I insert a column next to the column or cell I linking to and format the entire column/cell to General. I then use the TRIM formula, which takes out all of the hidden spaces. I then click the lower right corner to run the formula down the entire column. Sort the column to ascending. And then reference to that General, TRIM, column. Everything should work then.

Answer by asad
Submitted on 1/4/2005
Rating: Not yet rated	Rate this answer:
I really don't know how to do a vhookup

Answer by mimi
Submitted on 5/5/2005
Rating: Not yet rated	Rate this answer:
i agree westie91

Answer by Allie
Submitted on 5/5/2005
Rating: Not yet rated	Rate this answer:
i agree westie91

Answer by Eccles
Submitted on 6/26/2005
Rating: Not yet rated	Rate this answer:
The format of the cell contents and the format of the cells are two different things in Excel. So changing the format of the cells through the "format->cells" option does not change the contents of the cell which is why you have to f2-enter on every cell. You can quickly format a column by selecting the whole column and the clicking on "text to columns" from the "Data" menu. Go through the wizard and when you get to the format screen you can choose the format of the cells. To change the column to text choose the text option or to change the column to numbers (assuming that it contains valid numbers) choose "general".

Answer by Chappy
Submitted on 2/17/2006
Rating: Not yet rated	Rate this answer:
You`re a genuis THANKS A MILLION TIMES!

Answer by yi
Submitted on 8/28/2006
Rating: Not yet rated	Rate this answer:
\\iuy8i fjkr7u ytoju otrykte hdohkmeorth etyoht tyoht htohmeth eythmteyh tkhmth dmhmhte dknbmdinmhenhirdth unhsjrkt irtg itg jtrm t t tt t t t t t t t

Answer by mahendra
Submitted on 7/20/2007
Rating: Not yet rated	Rate this answer:
vlookup it is a very good fx

Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer: