Hi! You guys have been so great in helping me set up this function and it has worked beautifully so far. I've run into a snag though.
I've double-checked all the arrays and references and can't for the life of me figure out WHY it is returning #N/A in this spreadsheet when it works in all others?
I did not sort anything before, I tried to be sure to have the first cell above the referenced lookup and whatever else I needed to do.
I'm stumped! Any ideas?
Thank you so much once again!
The Vlookup is failing.
There is a space at the end, in cells of column "B" in sheet "Actual 6020"
Column AA in "FC Mark" has 6 leading spaces, while ColumnA in "Actual has 5.
You are using the same "mid" parameters for both columns, hence creating an extra space in that column.
Last edited by Portuga; 04-03-2008 at 04:25 PM.
If you found the solution to your question. Mark the thread as "Solved"
Thank everyone that helped you with a valid solution by clicking on their
There is no such thing as a problem, only a temporary lack of a solution
The values in column AB don't exactly match the values in Column B of your Actual 6020 sheet... one returns a blank before your 6-digit code and the other returns a blank after the 6-digit code....
Try:
In B3 of Actual 6020: =MID(A3,6,6) copied down
In AB3 of FC Mark: =MID(AA3,7,6) copied down
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.
Thank you! Problem solved!
I didn't even think about counting the spaces in that formula! DUH!
Goes to show when you stare at something long enough you lose complete sight!
Thank you again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks