+ Reply to Thread
Results 1 to 2 of 2

looup working in 1st column and not in others

  1. #1
    Forum Contributor
    Join Date
    12-23-2007
    Location
    chennai india
    MS-Off Ver
    2010
    Posts
    141

    looup working in 1st column and not in others

    I have used lookup for picking data from other sheet. The Ist colums work perfectly but other columns do not work. Sample sheet is enclosed.
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,138

    Re: looup working in 1st column and not in others

    Can you explain exactly what you are trying to achieve?
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: looup working in 1st column and not in others

    Maybe this will work for you: I changed the formula in column L of Data to give TRUE or blank. TRUE will be recognized in the formula in the WORKING worksheet.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 2 Dimensional looup with Quantity Breaks
    By stephboucher in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-29-2014, 09:30 AM
  2. [SOLVED] Setting individual column width sizes for multi column listbox with VB2011 Mac not working
    By Nitefox in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 01-26-2014, 06:19 PM
  3. Macro from moving from column 12 to the next row of column 5 not working
    By catchnanan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-05-2013, 05:58 PM
  4. Need copy the column d instead of column b, macro working fine for column b
    By audax48 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-20-2012, 04:32 PM
  5. Excel 2007 : LOOUP or MATCH Function?
    By LAB2007 in forum Excel General
    Replies: 2
    Last Post: 07-09-2010, 01:24 PM

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