F
fi.or.jp.de
Hi,
I have worksheet with data as follows :
Col A Col B
ABC 123
ABC 234
ABC 345
AC 456
AC 567
AC 678
In Another Sheet I have
Col A
If the user inputs the ABC in cell A2 then
I need in Col D
123
234
345
I was using formula
=INDEX(Sheet1!$B$1:$B$10,SMALL(IF($A$2=Sheet1!$A$1:$A$10,ROW(Sheet1!$A
$1:$A$10),""),ROW(1:1)),0)
I am looking for VBA solution.
I have worksheet with data as follows :
Col A Col B
ABC 123
ABC 234
ABC 345
AC 456
AC 567
AC 678
In Another Sheet I have
Col A
If the user inputs the ABC in cell A2 then
I need in Col D
123
234
345
I was using formula
=INDEX(Sheet1!$B$1:$B$10,SMALL(IF($A$2=Sheet1!$A$1:$A$10,ROW(Sheet1!$A
$1:$A$10),""),ROW(1:1)),0)
I am looking for VBA solution.