I've been using vlookup for years. Recently, it has stopped working properly for me.
I have two sheets in the same file. When I use vlookup from sheet 1 to find a matching value on sheet 2 (Lawyers), I get #N/A in all cases.
My cell formula is =Formula:
Please Login or Register to view this content.
Could someone please shed some light on this for me?
Last edited by Jazzzbo; 06-18-2014 at 12:34 AM. Reason: Adding Workbook
Hi Jazzzbo,
Provide a sample Work Book,
Punnam
Generally, for an exact match, you would set the fourth parameter to FALSE. And, if you intend to copy the formula, the range should be absolute.
Formula:Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
TryIf you still get #N/A, then maybe your data in column M in Sheet1 contains leading / trailing spaces or does have match due to uppercase / lowercase strings. Or the match phrases in Lawyers sheet has leading / trailing spaces or may not match due to the case-sensitivity as well. If it doesn't work, post a sample workbook with insensitive data.Formula:Please Login or Register to view this content.
Last edited by Saarang84; 06-18-2014 at 12:22 AM.
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
I'm pretty sure VLOOKUP isn't case sensitive. But you can have issues with numeric numbers vs text "numbers".
Regards, TMS
One thing to watch out for is if you are comparing numbers with text (for example if this involves invoice numbers).
If, for example, M9 is a number and the lawyers sheet may contain some references that are text (and you want to work with text) you can use.
or if it is the other way around
Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks