sorry, i didn't know the standard in posting a message. this was my
first and just saw an option to do so. i'm not sure were in
Excel.programming I should be looking?

thanks,

"Frank Kabel" wrote in message ...
Hi
see your respones in Excel.programming

P.S: please don't multipost


--
Regards
Frank Kabel
Frankfurt, Germany

ruchir wrote:
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.