Pulling Data from Vlookups & finding matches

[jeremy.]

Hi,

I'm fairly new to VBA, and programming in general, so i apologize in advance.

Right now i have two columns. One is a list of abbreviations and the other is a corresponding number next to it depending on the abbreviation. In another worksheet I have a input cell that corresponds with a Vlookup so if you write the abbreviation in the cell you get the matching number next to it.

This is where i need help. Once the matching number appears, i want excel to go back to the columns and search for the abbreviations with that same number next to them then posted them below the original abbreviation that i have in the input cell.

I would assume i need to be using some kind of Find & Match code but I'm not sure how to make this work. Any help would be greatly appreciated.

 

[jeremy.]

Is this clear or am I not making sense? would a screen shot help?

 

[VoG]

You need to be more specific as to the sheets and ranges involved.


Try this to post screenshots http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

 

[jeremy.]

thank you. here is an example of what i'm trying to achieve in a more basic format.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1	*	*	*	*	*	*	*	*	*	*	*	*
2	*	*	*	*	*	*	*	*	*	*	*	*
3	*	*	*	*	*	*	*	*	*	*	*	*
4	*	*	*	*	Number	*	*	*	*	*	*	*
5	Input cell:	*	ab	*	2	*	*	*	*	*	*	*
6	*	*	*	*	*	*	*	*	*	*	*	*
7	*	*	*	*	*	*	*	*	*	*	*	*
8	*	*	*	*	*	*	*	*	*	abbreviation	Number	*
9	*	*	*	*	*	*	*	*	*	aa	1	*
10	*	*	*	*	*	*	*	*	*	ab	2	*
11	*	*	*	*	*	*	*	*	*	ac	2	*
12	*	*	*	*	*	*	*	*	*	ad	2	*
13	*	*	*	*	*	*	*	*	*	ae	3	*
14	*	*	*	*	*	*	*	*	*	af	4	*
15	*	*	*	*	*	*	*	*	*	ag	4	*
16	*	*	*	*	*	*	*	*	*	*	*	*
17	*	show other corresponding abbreviations that match number "2" in cell E5	*	*	*	*	*	*	*	*	*	*
18	*	*	*	*	*	*	*	*	*	*	*	*
19	*	*	*	*	*	*	*	*	*	*	*	*
20	*	*	*	*	*	*	*	*	*	*	*	*
Sheet1

 

[Aladin Akyurek]

thank you. here is an example of what i'm trying to achieve in a more basic format.

...

C4, just enter:

=COUNTIF($K$9:$K$15,E5)

where E5 houses 2.

C5, control+shift+enter, not just enter, and copy down:

=IF(ROWS(C$5:C5)<=C$4,INDEX($J$9:$J$15,SMALL(IF($K$9:$K$15=E$5,
    ROW($J$9:$J$15)-ROW($J$9)+1),ROWS(C$5:C5))),"")

 

[T. Valko]

thank you. here is an example of what i'm trying to achieve in a more basic format.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1	*	*	*	*	*	*	*	*	*	*	*	*
2	*	*	*	*	*	*	*	*	*	*	*	*
3	*	*	*	*	*	*	*	*	*	*	*	*
4	*	*	*	*	Number	*	*	*	*	*	*	*
5	Input cell:	*	ab	*	2	*	*	*	*	*	*	*
6	*	*	*	*	*	*	*	*	*	*	*	*
7	*	*	*	*	*	*	*	*	*	*	*	*
8	*	*	*	*	*	*	*	*	*	abbreviation	Number	*
9	*	*	*	*	*	*	*	*	*	aa	1	*
10	*	*	*	*	*	*	*	*	*	ab	2	*
11	*	*	*	*	*	*	*	*	*	ac	2	*
12	*	*	*	*	*	*	*	*	*	ad	2	*
13	*	*	*	*	*	*	*	*	*	ae	3	*
14	*	*	*	*	*	*	*	*	*	af	4	*
15	*	*	*	*	*	*	*	*	*	ag	4	*
16	*	*	*	*	*	*	*	*	*	*	*	*
17	*	show other corresponding abbreviations that match number "2" in cell E5	*	*	*	*	*	*	*	*	*	*
18	*	*	*	*	*	*	*	*	*	*	*	*
19	*	*	*	*	*	*	*	*	*	*	*	*
20	*	*	*	*	*	*	*	*	*	*	*	*
Sheet1

Is this what you had in mind:

http://www.mrexcel.com/forum/showpost.php?p=2696961&postcount=3

 

[jeremy.]

that's perfect. thanks alot!

 

[T. Valko]

that's perfect. thanks alot!

You're welcome. Thanks for the feedback!

 

[Aladin Akyurek]

that's perfect. thanks alot!

You are welcome. Thanks for providing feedback.