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 Look up one value and return multiple corresponding values

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 29-07-2009
Member
 
Join Date: Jan 2009
Posts: 58
Excel Look up one value and return multiple corresponding values
  

I have created a excel file which contains names and contact number of more then 5000 people along with there pin code number which many of them are repeated i want to I want to look up all the repeated values against a single value i mean to say the when i lookup for any one value it should return me multiple corresponding values respectively.

Reply With Quote
  #2  
Old 29-07-2009
Member
 
Join Date: May 2008
Posts: 4,828
Excel Look up one value and return multiple corresponding values

Try to use the following formula hope it works for you

using advance filter take out unique names in Col A paste it in Col C

C2 you have names in D2 put this formula and drag it down

Code:
=IF(ISERROR((INDEX($B1$1:$B1$100,SMALL(IF($A$1:$A$100=$C$2,ROW($A1$1:$A1 
$100)),ROW(1:1)),0))),"",INDEX($B1$1:$B1$100,SMALL(IF($A1$1:$A$100=$C 
$2,ROW($A1$1:$A1$100)),ROW(1:1)),0))
Reply With Quote
  #3  
Old 29-07-2009
Member
 
Join Date: Jan 2009
Posts: 58
Excel Look up one value and return multiple corresponding values

I have try to use the above formula but it's not working for me is there any other method which i can use it and thanks for replying me.
Reply With Quote
  #4  
Old 29-07-2009
Member
 
Join Date: Apr 2008
Posts: 2,139
Lookup Two Values In A List And Return Multiple Corresponding

Try to use the below steps hope it works for you.
  1. Select any cell within the source table
  2. Then click on Data , then Pivot table, Click twice Next
  3. Now wizard would get open over here click on Layout,
  4. Over here Drag and drop "Name" into ROW area and Drag and drop "number" into DATA area 3 times, one below the other leave the 1st as Sum.
  5. Now Doubleclick on the 2nd- - >select Max under Summarize by- - > click on OK
  6. Double-click on the 3rd- - >select Min under Summarize by- - > Click on OK
  7. Finally click on OK and finish
Reply With Quote
  #5  
Old 30-07-2009
Member
 
Join Date: Dec 2008
Posts: 101
Excel Look up one value and return multiple corresponding values

Check out the below links to this will give you some idea how to do it.

Excel : vlookup multiple values
Help-How to select multiple values using lookup function???
Need help for vlookup function
How to use vlookup for rounding up numbers in Excel 2003
Reply With Quote
  #6  
Old 27-10-2009
Member
 
Join Date: Oct 2009
Posts: 1
Re: Excel Look up one value and return multiple corresponding values

Hi
I have a data that has a particular number in sheet 1 and the database in in the second sheet, I need to know how many times payment has been made and amounts to be listed in cells next to the number
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Excel Look up one value and return multiple corresponding values"
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
Excel 2010: Can VLOOKUP return multiple non-empty values from a table? marathon MS Office Support 3 21-01-2012 01:43 AM
Lookup multiple values in excel Alatar1313 Windows Software 1 09-12-2009 02:49 AM
php return multiple values Aston5 Software Development 2 29-06-2009 11:14 PM
Excel : vlookup multiple values Laler Windows Software 3 25-06-2009 11:27 AM


All times are GMT +5.5. The time now is 06:04 PM.