Thread: how to use vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tkraju via OfficeKB.com tkraju via OfficeKB.com is offline
external usenet poster
  
Posts: 109
Default how to use vlookup
Actually Vlookup finds first occurance of a value in vertical looup.Ineed
code for last occurance.

muddan madhu wrote:
Application.WorksheetFunction.VLookup(TextBox1.Te xt, Range("A1:B10"),
2, 0)

how to use vlookup function in Vba.
I need Â*Vlookup(userform.textbox1.value,w/sheet1.range("A1"A25",2,false)

--
Message posted viahttp://www.officekb.com

--
Message posted via http://www.officekb.com

Reply With QuoteReply With Quote