Results 1 to 2 of 2

Thread: Excel lookup query

  1. #1
    Join Date
    Oct 2009
    Posts
    1

    Excel lookup query

    Hey all, have what should be a simple problem. Column B say consists of mostly 0s. I want to return to column C the next value >0.

    B C (what I want returned)

    0 200
    0 200
    200 200
    0 500
    0 500
    0 500
    0 500
    500 500
    etc

    Any ideas?

  2. #2
    Join Date
    Dec 2007
    Posts
    2,297

    Re: Excel lookup query

    You can try looking to go for the pivot tables as it gives you exactly what you are looking for and it is also very easy to use if comapared to formulas that come in question for any task. So try utilizing a pivot table or an advanced filter if it's only one name at a time. Also, to return a result from the left of your lookup value, use the MATCH and INDEX functions. Hope that helps you out.

Similar Threads

  1. EXCEL Lookup the same value that has multiple values
    By horse43 in forum Windows Software
    Replies: 1
    Last Post: 09-06-2012, 11:42 AM
  2. How to sum by using Lookup on Excel?
    By Gowravaram in forum Windows Software
    Replies: 5
    Last Post: 04-01-2012, 06:52 PM
  3. LOOKUP.XLAM is already open in Excel 2007
    By Japheth in forum Windows Software
    Replies: 6
    Last Post: 27-05-2010, 05:59 PM
  4. Lookup multiple values in excel
    By Alatar1313 in forum Windows Software
    Replies: 1
    Last Post: 09-12-2009, 01:49 AM
  5. Cell intersection lookup in excel
    By Sayam in forum Windows Software
    Replies: 3
    Last Post: 30-07-2009, 10:51 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •