VBA match, index, lookup... confused

Hi there,

I'm just looking at VBA for the first time. I'm coming from a PHP, BASH and assorted other Linux languages background. Short of throwing this Excel spreadsheet into a MySQL DB and doing what I want on the server in PHP, I thought I would poke around with this VBA stuff and maybe learn something new.

I have a rather large spreadsheet that is based on about 12 worksheets (9k+ rows) and it's been a blast learning how to tie them in to one another with Excel functions.

I have to find a way to search row 1 (in one of those worksheets and then return all the data in that row.

I thought I would insert an Excel 5.0 dialog. Create an input form to match the input to the worksheet then return the row info in a nicely formatted page.

I see there is some scripting capability here, but I'm not sure where to start.

I've done some searching over the past two days, including this forum, and some people have mentioned a match function, but I'm not sure where the resources on VBA are. I went to the VBA Excel document site at msdn.microsoft.com, but I can't drill that thing for anything.

If anyone has an example I could work off of or a couple of URL's to documentation that would be appreciated! There doesn't seem to be a whole heap of people out there who cover this kind of stuff.

I've got about a three days to put this together or I'll have to drop the project and go with what I know.

(Sorry about the double post. My bad.)