Validate two words from cell using two other columns Microsoft Excel
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Validate two words from cell using two other columns Microsoft Excel
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    40,449
    Post Thanks / Like
    Mentioned
    86 Post(s)
    Tagged
    19 Thread(s)

    Default Re: Validate two words from cell using two other columns Microsoft Excel

    Quote Originally Posted by dskribow View Post
    Ok, that makes more sense. Thank you, Peter_SSs.
    You are welcome.
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

  2. #12
    New Member
    Join Date
    Nov 2015
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Validate two words from cell using two other columns Microsoft Excel

    Ok, so, I've actually got another related question. How can I make this work in VBA?

    Here's what I'm trying to do: WorksheetFunction.Index(Sheet2.Range("Customer_Table"), WorksheetFunction.Match(Sheet13.Range("C3"), Sheet2.Range("Customer_Table[FName]") & " " & Sheet2.Range("Customer_Table[LName]"), 0), 1)

    I keep getting a typ mismatch error.

    ...any ideas?

  3. #13
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    40,449
    Post Thanks / Like
    Mentioned
    86 Post(s)
    Tagged
    19 Thread(s)

    Default Re: Validate two words from cell using two other columns Microsoft Excel

    Quote Originally Posted by dskribow View Post
    Here's what I'm trying to do:
    Actually, you gave us some code that apparently doesn't do what you are trying to do. So how should we deduce what you are trying to do?

    How related to the previous question is this?
    We haven't previously learnt what Sheet2 and Sheet13 are and what "Customer_Table" is. Whilst we can guess, it would be good to know for sure. Also, what is this code part of?

    Are you trying to use vba instead of the built-in Data Validation? If so, how and why?

    The more background & understanding we have, the better chance of getting to the best solution quickly.
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

  4. #14
    New Member
    Join Date
    Nov 2015
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Validate two words from cell using two other columns Microsoft Excel

    Hi, Peter_SSs...was hoping that there was a simple syntax or logic error somewhere in there.


    My issue is somewhat related to my precious data validation question, but I figured that I should create a new thread for it here: http://www.mrexcel.com/forum/excel-q...lications.html

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
  •