So I'm trying to use
=IFERROR(VLOOKUP(D2,'Sheet2l'!$A$2:$M$2467,6,FALSE)>P2,VLOOKUP(D2,'Sheet2'!$A$2:$M$2467,6,FALSE))
I tried using it with IF instead of IFERROR as well and it didn't work
using
=IF(VLOOKUP(D2,'Sheet2'!$A$2:$M$2467,6,FALSE)<=P2,VLOOKUP(D2,'Sheet2'!$A$2:$M$2467,6,FALSE),"")
which produces 1/0/1900 for anything that has a blank in Sheet2
Any way to fix the 1/0/1900's and the #N/A's that come with the second formula?
1st of all, IFERROR() is used to show/do something else (which you define) if your formula returns an error - in essence a form of IF() but only for errors...
=IFERROR(your formula [gives error], then do this instead)
Try thi perhaps...
=IFERROR(VLOOKUP(D2,'Sheet2l'!$A$2:$M$2467,6,FALSE),"")
you give no indication or what is in P2?
if you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
The VLOOKUP is returning a zero for cells that are blank ... and I'm guessing the cell is formatted as a date. You need to specifically test if the value is blank. For example, =IF(VLOOKUP(...) = "", "", VLOOKUP(...))
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
Withdrawn by FR.
Dave
One option is to stick with your original formula but custom format result cells as
m/d/yyyy;;
By using the two semi-colons you will get blanks instead of 1/0/1900 (although the underlying value will still be zero)
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks