I'm using a vlookup formula and the formula is returned as the result instead of a value. Any idea why this is happening?
I'm using a vlookup formula and the formula is returned as the result instead of a value. Any idea why this is happening?
check to make sure that the formmat for that cell is not TEXT. If it is, change it to general or Number...then F2 and enter
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
That worked perfectly!!! Thanks so much!!
Happy to help. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neet and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks