+ Reply to Thread
Results 1 to 13 of 13

comparing values and returning different column

Hybrid View

  1. 05-31-2007, 06:57 PM #1
    BigBas
    BigBas is offline
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    How about:

    =VLOOKUP(B2,SHEET2!A1:A100,2,FALSE)

    Let me know if that works
    Reply With QuoteRegister To Reply
  2. 05-31-2007, 07:15 PM #2
    JustMe602
    JustMe602 is offline
    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.
    Reply With QuoteRegister To Reply
  3. 05-31-2007, 10:22 PM #3
    BigBas
    BigBas is offline
    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1