Results 1 to 2 of 2
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Arrange vlookup (2000 sr 1)

    I use this comde to finde a vlue and put it into a cell...
    Have difficult to arrange this...
    I would want to find into table into sheet SALDI (range P:Q) and put into cell C5 of sheet FOGLIO97) the index is in B5 of sheet FOGLIO97...

    Elenco.Range("S" & Trim(CStr(N))).Value = Application.WorksheetFunction.VLookup(Range("D" & Trim(CStr(N))), _
    Worksheets("ABICAB").Range(Worksheets("ABICAB").Ra nge("C2"), Worksheets("ABICAB").Range("D65536").End(xlUp)), 2, False)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Arrange vlookup (2000 sr 1)

    You don't need code to do that, just put the appropriate formula in cell C5.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •