VLOOKUP - location of value

I

iaguirre

I'm writing a VB script that reads from excel file....if I wanted t
look up a value in a certain column I use this....
xlObj.WorksheetFunction.VLookup(trdNbr, xlObj.Range("K:K"), 1, False)

what I would like to know is how to find the excel row number that th
value was found on......

please help!!!:confused
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate the median value before a specified list 0
trouble with (complicated) vlookup searching another workbook 2
VLOOKUP & Data Validation 0
Drop down list control value in vba 2
Vlookup Returning Zero For Every Cell 3
Multiple VLOOKUP in an IF statement 2
VLOOKUP duplicate values in table the table array? Help me solve 1
Using a vlookup to search multiple criteria for one result? 7

Top