Hi Everyone,
This is driving me mad! I have a DATA worksheet containing alpa numeric and numeric references both formatted as such. When I try to VLOOKUP the numeric value, it does not find the value although I know it's there. Even when I put an apostrophe in front of the number on the MAIN SHEET, it still does not find it.
I'm getting my knickers in a right old twist and will probably kick myself if it turns out to be something really simple.
Any help would be very gratefully received.
Andy
Hi select column A (main sheet) and choose "text to columns" command -> click 2 times next button -> click finish button. Do the same with column B. It should help
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Hi Tom, thanks for your reply. It did help but I don't think it found all of them. Am checking at moment and will let you know.
Last edited by watchouse; 06-25-2012 at 08:19 AM.
I checked a few numbers with #N/D! and You do not have them in sheet Data so in my opinion evertything is ok
Yeah, think you are right. Thanks for your help! Now need to get my data up to date
Good luck then and thx for rep. points
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks