Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Excel lookup query

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 30-10-2009
Member
 
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?

Reply With Quote
  #2  
Old 23-06-2012
Member
 
Join Date: Dec 2007
Posts: 2,273
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.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags:



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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


All times are GMT +5.5. The time now is 10:08 PM.