Getting row number of VLookup return

[ChuckDrago]

Hi everyone,

I have a large table which is queried by a macro to find a specific record. If the queried record exists, then it is retrieved for editing. If it does not, a message announces its omission and then the user creates it.

I am using VLookup, using the Part Number (record ID) as the search key. If a match is found, I'd like to obtain the ROW NUMBER corresponding to such record in the source table.

How?

Thanks,
Chuck

 

[Domski]

Do you mean you are using VLOOKUP in your macro? Maybe have a look at using the Find Method instead which will return the range of any match it finds and then you can obtain the row from that.

Dom

 

[ChuckDrago]

Care to show me an example, Domski?

 

[Domski]

There's a pretty good example in the VBA help that I always use.

Dom