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.