If there is no match, I'd like to enter my own value. Just can not
figure out how to write code! 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 Exit Sub Else run code?
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
