+ Reply to Thread
Results 1 to 2 of 2

Validate/lookup excel data against Sharepoint List

  1. #1
    Forum Contributor
    Join Date
    08-21-2008
    Location
    Hamilton, New Zealand
    MS-Off Ver
    Office 2007
    Posts
    255

    Validate/lookup excel data against Sharepoint List

    I want to be able to lookup/validate with vba a combination of values to match that against that of a sharepoint list.
    Is this possible ?

    list column format being -
    category, role, userid
    a, b, c
    a, b, d
    a, b, e
    x, y, z
    x, y, x
    1, 2, 3

    So if list record matches
    example 1
    - Category= a
    - role = b
    - userid = e
    would return true

    example 2
    - Category= a
    - role = b
    - userid = x
    would return false

  2. #2
    Forum Contributor
    Join Date
    08-21-2008
    Location
    Hamilton, New Zealand
    MS-Off Ver
    Office 2007
    Posts
    255

    Re: Validate/lookup excel data against Sharepoint List

    Bump .........

    Any ideas ?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1