Using MATCH within VBA to find a row number used elsewhere in code

[jacob@thepenpoint]

Hi All

I have a file I am trying to use to view / update data in a large table located in a separate workbook. The user will enter the item they want to review in cell B2 in one workbook and the cells are all using an Index/Match to pull in the data from the other workbook. I have an area to modify the information and then they can push "Update" and the new data will write to the data table in the other workbook. My problem is getting the row number from the item number the user has keyed in.

Here is my latest attempt to return the row number:

udRow = WorksheetFunction.Match(Cells(2, 2), dbBook.Cells(1, 2).Resize(dbLastRow, 1), 0)

I would put everything in one file, but there are dozens of different workbooks that access the information in this table and everything seems to lose its mind when I change the file extension to .xlsm in order to save the macro.

I would certainly appreciate any input on how to get this row number.

Thanks