multiple results search

[ruchir]

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.

 

[Alan Beban]

If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, then
assuming that your data starts at Cell A1 on Sheet2:

=ArrayRowFilter1(Sheet2!A1:C5,1,"ab12345") array entered into a range on
Sheet1 sufficiently large to accept the output.

Alan Beban

 

[Frank Kabel]

Hi
see your respones in Excel.programming

P.S: please don't multipost

 

[Paul Valenzano]

Perhaps my question is how do I properly enter the function into a
range of cells? It doesn't seem to be filling the range with the
function, no matter how I select the cells I want to put the results
in.

I've tried naming my range, and setting the function while the name is
selected. I've also Ctrl+R Ctrl+D filled the selection (didn't
honestly think that would work, but I figured I'd try it).

Thanks for the help thus far, Alan

-Paul Valenzano

 

[Alan Beban]

What error messages do you get? Are you array entering (i.e., entering
with Ctrl+Shift+Enter instead of just Enter) the function?

Alan Beban

 

[Paul Valenzano]

That solved it, thanks alot for your help.

What error messages do you get? Are you array entering (i.e., entering
with Ctrl+Shift+Enter instead of just Enter) the function?

Alan Beban