Table search and position output question

I haven't had any experience with VBA, but I have had some experience with C++, and I know that in C++, I could code a couple nested loops to run through a table (matrix) by row to search for an particular entry.

What I'd want to do when the entry was found would be to store the location (row/col) in some local variable, then output the first entry of the row and column of that cell (the headings). This would let me output something like the date in month/year format that a specific record occurred.

Anyone suggestions?

It looks like the value that I'd be interested in is what would be stored in the firstAddress variable, as that would be the reference to the location of the match. I'm not actually interested in changing any values, so the c.Value reassignment can be omitted. Since each entry in my table is unique, this method should only assign firstAddress one time.

Here's the next question, I guess:

If I write this into a macro, how would I structure the thing to take in a value and return the value of firstAddress?

What I'd like would be something like Find_Match(55) to be my function, where 55 is what I want to search for, and upon writing that into a cell, the displayed result is something like B7.

The ultimate goal will be to eventually display the row and column header for that cell, so if there's a better approach to this end than by going through the cell address, I'd probably prefer that.

Sorry if I'm not getting somet of this right. I'm still really fuzzy on how to define variables and inputs and impliment macros.

I have my row headings in column A, and my column headings in row 1. Having a way to store the row and column numbers of the cell containing the sought entry is awesome, but I'm wondering now if there's a way to add to the macro some output of the row and column headers for the entry it finds.

Also, I'm not sure if I'm entering the code correctly, but the VBA compiler is having trouble when I try to run the macro. It's indicating some "non optional" problem with the Sub FindIt() line. I have no idea what that means.

I hate being a bother, but the VBA help topics can't really teach me the object properties and syntax I'm having trouble with.

Another question is, will this code, in some final form, simply display the result in the cell, or will there be some "MsgBox" popping up? For ease of use (this function will mainly be a time-saving shortcut to looking up tabled values from a large worksheet), it'd probably be best if there were just a cell into which a user can type the value they wish to find, and the output could exist in another cell below, displaying the row and column header of the entry once it is found in the table.

Does the MsgBox Cells(1, c).Value line provide the output?
Does the str line cause a pop-up field? Would there be a way to allow the input in some form of typing =FindIt(55)?

I'm very thankful for all the help already.

This is the table I'm working with. I want to be able to add a calculation field somewhere in the workbook that, when a value from the table is typed in, the month and year are returned. So, instead of someone having to dig through the table for 2550, they can just type it in and get the date they want.

What would be perfect would be some function that I could type in another sheet, with the number as an argument, and then upon entering that, the return would be the date, formatted as "Month, Year". I don't know how to go about the formatting, really, but the code you listed before looked like a really good step ahead of where I've been stuck.

Awesome work, Roy. You saved me a headache, I'm sure!

Though I'll probably have to learn some VBA sometime...

Thanks though!