File: http://tempsend.com/DF0121B557
Sheet 2
After around row 7981, I do not see anymore successful lookups from either Vlookup, or IndexMatch. I'm sure it's something simple I've overlooked...
The purpose of the spreadsheet is to identify which Part numbers have not been used in the past three years. I thank you for any help.
Try this
VLOOKUP(A2, $A$35029:$B$43124, 2,FALSE)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
You should use absolute row references by putting a $ in front of them, so that they do not change when you copy the formula down. In F2, for example, you should have this:
=VLOOKUP(A2, A$35029:B$43124, 2,FALSE)
and then copy it down. Similarly in G2.
Hope this helps.
Pete
Thanks, guys!
You're welcome and thank you for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks