+ Reply to Thread
Results 1 to 3 of 3

WorksheetFunction.Lookup Error

  1. 11-21-2017, 08:02 AM #1
    mohan.r1980
    mohan.r1980 is offline
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    WorksheetFunction.Lookup Error

    Hello,

    i am trying to get the last String from columns. (Column Y)

    i am using lookup function for that but it shows me type mismatch error.

    Please Login or Register  to view this content.
    Please suggest me
    Last edited by mohan.r1980; 11-22-2017 at 03:07 AM.
    Reply With QuoteRegister To Reply
  2. 11-21-2017, 08:25 AM #2
    xlnitwit
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: WorksheetFunction.Lookup Error

    Hi,

    You can't divide a number by a range like that in VBA. You could use Evaluate
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.
    Reply With QuoteRegister To Reply
  3. 11-22-2017, 03:07 AM #3
    mohan.r1980
    mohan.r1980 is offline
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: WorksheetFunction.Lookup Error

    hi xlnitwit,

    Thanks for suggestion.

    it works fine
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Worksheetfunction Vlookup error
    By Crispy85 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-14-2017, 05:30 AM
  2. [SOLVED] Worksheetfunction.lookup works sometimes and errors out other times..
    By adamstarr12 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-29-2015, 11:17 AM
  3. [SOLVED] Error using worksheetfunction between workbooks
    By Sean Thomas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2013, 05:43 AM
  4. [SOLVED] Error Using WorksheetFunction.SumIf
    By unvme1212 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-18-2013, 01:52 PM
  5. WorksheetFunction.lookup
    By thestappa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-25-2010, 02:54 PM
  6. worksheetfunction.vlookup gives #VALUE! error in VBA
    By ses9 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2009, 10:12 PM
  7. [SOLVED] worksheetfunction.sum error
    By Monique in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-17-2005, 12:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1