Instead of VLOOKUP, use MATCH to find the (relative) row and assign this to a
variable. Then use the variable in INDEX to retrieve the other data as well
as to update the data if necessary.

Hope this helps.

Pete

" wrote:

I'm currently implementing a user form that is meant to add new rows
or update existing rows on a worksheet. I'm currently using a VLookup
to determine if the item I want to add already exists on the
worksheet, and if it does, I'm loading the row information with
additional VLookups. The problem is, I need to be able to get back to
this source row in order to update it with any changes made to the
data in the user form. Does anyone have any suggestions as to how I
might be able to determine the row number or address of the cell that
is identified by the vlookup function? (I have enumerated constants
defined to handle my columns).

I should probably point out that I need to do this all in VBA. I
realize that I could store the address in a cell in the row and load
it into a variable when I load the rest of the rows data, but I'd
prefer to only store relevant data in the row and handle this
programmatically.

Thanks in advance for any help.
JR