Steve -

I haven't used Alan Beban's functions, but since it seems to be an array
function, you should first select the range where you want the results to
appear (from your description it should be two columns and many rows, and
it's usually OK to select more rows than you really need), second type the
equal sign and the function with its arguments but don't press Enter,
finally hold down Control and Shift while you press Enter, thus "array
entering" the function.

- Mike
http://www.mikemiddleton.com


"SteveT" wrote in message
...
The website is http://home.pacbell.net/beban/ and there is a function in
there that would really help me (arraymatch) and I can't figure out how to
use it properly. When I use the wizard and enter the value and the array
range it correctly shows the output data at the bottom of the window but I
don't know how to make it display in the worksheet. It is supposed to
output
the results in a two column array indicating the row and column of all
matches. All I get is the first match row number.

Thanks
Steve