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

Thread Tools Search this Thread
Old 30-10-2009
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

Any ideas?
Reply With Quote
Old 23-06-2012
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

  TechArena Community > Software > Windows Software

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 11:42 AM
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 05: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 10:51 PM

All times are GMT +5.5. The time now is 10:55 AM.