Results 1 to 2 of 2

Tring to import data from another sheet providing condition is met

Threaded View

  1. #1
    Registered User
    Join Date
    04-08-2009
    Location
    Sheffield
    MS-Off Ver
    Excel 2003
    Posts
    5

    Tring to import data from another sheet providing condition is met

    Hi I have a workbook which has an overview sheet of user access and subsequent sheets with levels of access.

    The one sheet contains Surname, First Name, User ID and Limit in each column.

    The other sheet contains User ID and Limits which can be in any random order.

    I want the limit column on the first sheet to look at the UserID in that particular row and search to see if the user ID exists in the other sheet. This can be anwhere in the first column. If the User ID matches, then it pulls in the Limit value into the cell where the formula is.

    Hope that makes sense!

    I have an example workbook attached.

    Can you think of a formula which can do this?

    Thank! :o)
    Attached Files Attached Files

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