i have an original set of data that is very large.
I have narrowed the records i want to show down to a few hundred and i would like to only show those records.
i would usually just use vlookup for this but the problem is that there can be more than one occurance of any given id code. so i vlookup would not return all the results.
does anyone have a suggestion on how to accomlish this?
thanks
I have narrowed the records i want to show down to a few hundred and i would like to only show those records.
i would usually just use vlookup for this but the problem is that there can be more than one occurance of any given id code. so i vlookup would not return all the results.
does anyone have a suggestion on how to accomlish this?
thanks
Book1 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | originallist | dataitem1 | dataitem2 | newlist | newlistshouldshow | dataitem1 | dataitem2 | ||||
2 | 1a | 2 | 555 | 1a | 1a | 2 | 555 | ||||
3 | 1a | 3 | 666 | 1d | 1a | 3 | 666 | ||||
4 | 1a | 4 | 777 | 5r | 1a | 4 | 777 | ||||
5 | 1d | 5 | 888 | 1d | 5 | 888 | |||||
6 | 1d | 6 | 999 | 1d | 6 | 999 | |||||
7 | 1g | 7 | 1110 | 5r | 11 | 1554 | |||||
8 | 1f | 8 | 1221 | ||||||||
9 | 1t | 9 | 1332 | ||||||||
10 | 3f | 10 | 1443 | ||||||||
11 | 5r | 11 | 1554 | ||||||||
Sheet1 |