I'd like to enter my own value if there is no match. As the code
stands now it will not allow
me to enter my own value, returns the #N/A error and each time I try
and change this it fires the code again and return the error again. I
need something like... If A3 = "#N/A" then Enter "Your Own Value"
Thanks in advance!!!
'Worksheets("Worksheet2").Range("B3").Formula =
"=if(A3="""","""",index('Customer Record'!B:B,match(A3,'Customer
Record'!A:A,0),1))"
'Worksheets("Worksheet2").Range("B3",
Range("A65536").End(xlUp).Offset(1, 1)).FillDown-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
