What's the closest thing to of vlookup in vba?

[User Name]

I want to look up a value in column F and return the value in the next column over. I'm successfully using the instruction below but I was wondering how this might be done in VBA without calling on a worksheet function?

Baseline_Quantity = Application.VLookup(Baseline_to_Find, Worksheets("Baseline Quantities").Range("F2:G200"), 2, False)

 

[Sthrncali]

You could write a custom function that will return the same result, however why would you if VLOOKUP gives you the result you need??

 

[User Name]

You make a good point. I was thinking a VBA based lookup function would be quicker. I was also thinking I should learn how to do a find from VBA just so I know how to do it. I thought it might come in handy some day. Make any sense?

But hey... No worries. vlookup works just fine for now.