Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return all values found for criteria
Microsoft 2003 - I am doing a vlookup to return the value of column 2
(description) if column 1 (name) on the other worksheet is equal to column 1(name) on the main worksheet. However, a name can show up more than once in the column 1 listing so I need it to return all values in column 2 each time it is found. The vlookup is finding the first time it matches and then stops. I need it to keep going down the column and return all values for that name back to my cell with the formula in it. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return all values found for criteria
Try to put the formula in the first row:
=INDEX($A$2:$B$6;MATCH($E$1;$A$2:$A$6;ROW()-1);2) $A$2:$B$6 is your table "$E$1" has the value that you want to find "2" is the second column (return) -- Rodrigo Ferreira "duketter" escreveu na mensagem ... Microsoft 2003 - I am doing a vlookup to return the value of column 2 (description) if column 1 (name) on the other worksheet is equal to column 1(name) on the main worksheet. However, a name can show up more than once in the column 1 listing so I need it to return all values in column 2 each time it is found. The vlookup is finding the first time it matches and then stops. I need it to keep going down the column and return all values for that name back to my cell with the formula in it. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return all values found for criteria
If you have more than one name match, then consider using Autofilter.
Autofilter will display the entire row for all the matches of a given name. -- Gary''s Student - gsnu200723 "duketter" wrote: Microsoft 2003 - I am doing a vlookup to return the value of column 2 (description) if column 1 (name) on the other worksheet is equal to column 1(name) on the main worksheet. However, a name can show up more than once in the column 1 listing so I need it to return all values in column 2 each time it is found. The vlookup is finding the first time it matches and then stops. I need it to keep going down the column and return all values for that name back to my cell with the formula in it. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return across Row Numeric Values Matching EXACT Month & Year for Criteria | Excel Worksheet Functions | |||
Return Numeric Values Matching EXACT Date for Criteria | Excel Worksheet Functions | |||
Vlookup, return zero if not found | Excel Worksheet Functions | |||
can lookup return err if no match found | Excel Worksheet Functions | |||
Return text found in a search | Excel Worksheet Functions |