+ Reply to Thread
Results 1 to 13 of 13

comparing values and returning different column

Hybrid View

  1. #1
    Registered User
    Join Date
    10-05-2005
    Posts
    34

    the vlookup didn't see to work.

    Due to the values needing to be in ascending order I do believe that is the reason that the Vlookup function will not work in the scenero. Both Sheet 1 & Sheet 2 are not in ascending order based off the information in Column B in Sheet 1 and Column A in Sheet 2.
    Last edited by JustMe602; 06-01-2007 at 10:18 AM.

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    It is possible that your lookup range and lookup array are not the same format. If you post a sample of your workbook, it will be easier to specify the problem.

+ 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