I'm trying to use VLOOKUP for a rate code that corresponds to a rate description. The table is on another worksheet in the same workbook, with the rate code in the first column, sorted by code. I have attached two JPEG images, the first of the worksheet with the VLOOKUP function, and the second is the worksheet with the lookup table. Thank you for your time!
Last edited by shinymcshires; 10-05-2007 at 12:55 PM.
It looks as though perhaps the numbers in AR are formatted as text?
Try to Select column AR in sheet 1 and go to Data|Text to columns and click Finish...
Does that fix it?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
That was it exactly. Funny- I've done that before, but not the text to columns option. I just formatted the cells to General, and that didn't work. This worked like a charm. Thanks for the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks