Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Using Index function in userform
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,177
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    49 Thread(s)

    Default Re: Using Index function in userform

    Don't think you can use an array formula like that, try
    
    Code:
    FindValue = ws.Evaluate("Index(E:E, match(1, (A:A = " & Val(Me.List_Sales.Value) & ") * (B:B =" & Val(Me.List_Details.Value) & "), 0))")
    Last edited by Fluff; Oct 3rd, 2019 at 02:54 PM.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  2. #12
    Board Regular
    Join Date
    Jun 2016
    Posts
    125
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Using Index function in userform

    Quote Originally Posted by Fluff View Post
    Don't think you can use an array formula like that, try
    
    Code:
    FindValue = ws.Evaluate("Index(E:E, match(1, (A:A = " & Val(Me.List_Sales.Value) & ") * (B:B =" & Val(Me.List_Details.Value) & "), 0))")
    Amazing, thanks a lot dear, it works very well

  3. #13
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,177
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    49 Thread(s)

    Default Re: Using Index function in userform

    My pleasure & thanks for the feedback
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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