Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup into tbl w/ duplicate values
Hi,
I need help with an array formula (CSE) or lookup that will return all values the lookup finds not just the first. Here is an example of my data, as u can see there are dups. brand1 blue brand1 green brand1 red brand2 yellow brand2 blue brand2 brown I'd like to be able to drag the formula down and have it return all values for 'brand1' not just the 1st one it finds. Been having difficulty manipulating vlookups & index(match) to accomplish this. Thanks for your help MattR |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MATCH() and duplicate values -- is there a workaround? | Excel Worksheet Functions | |||
Is there a way MATCH() can cope with duplicate values? | Excel Worksheet Functions | |||
LOOKUP 2 DIFFERENT VALUES AT ONE TIME AND RETURN A VALUE | Excel Worksheet Functions | |||
Lookup Function - Specific Values | Excel Worksheet Functions | |||
Need help with lookup and comparing values | Excel Worksheet Functions |