Hello Ron,

Thank you. With this bit of information the lesson makes sense.

Are there things like "1:2" or "2:2" or "2:1" that I should be alert to?

Thanks again,

Bob

"Ron Coderre" wrote:

The 1:1 in the array indicates ALL of Row_1.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Knot2Brite" wrote:

Hello,

I am working on an Excel course from OzGrid.

One of the problem/examples defines the MATCH function Array as 1:1. In my
ignorance I expected something like A1:G50.

I can't find in Help an explanation of what "1:1" defines. I will
appreciate some guidance.

Thanks

Bob