multiple results search
i am having trouble searching for a value that has multiple entries
from sheet1
enter a value: ab12345
search for all rows that have value ab12345 in sheet2 and paste in sheet1
in sheet2
ab12345 name1 number1
ab12345 name2 number2
ab12345 name3 number3
ab12345 name4 number4
ab12345 name5 number5
if anyone can i help, i would greatly appreciate.
|