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

    VLOOKUP MULTIPLE (excel 2000)

    http://www.gssitaly.com/RATEDEF_29012004.ZIP

    This is a system of pay rool.

    Definition of columns an cells:

    SHEET ANAGRAFE
    A=ID
    B=Name
    C=Agency
    D=Class of employee
    E=How many year of the payment
    F=Number of payemnt
    H=interess
    I=Amount
    J=Residual Amount
    K=init first payment
    L=Next payment
    M=Constant paymnet
    N=Percentage of total payment
    O=And payment
    P3=Interess
    R=Index for the relation in to sheets 12,24,36,48,60 (This column Autocompose in to refer paymnet)

    SHEET GRADO
    Grid refered for the Max amount to require.

    SHEETS 12,24,36,48,60 Plain of payment (in month)
    This cells is the same for every sheets
    A7=Amount
    A11=Number of payment
    A9=Interess

    SHEET RATE symply dbase of payment (non important for my problem)

    PROBLEM:

    Many part of this workbook is maked with a formulas but i m sure that i wuold want to be make with a macro(?!)

    I explain for one cell, but the macro must run if in the value in the column I is balnk.

    EXPLAIN

    In the sheet ANAGRAFE cell I3 is 12.500,00, this data is created from a vlookup in D3 from sheet GRADO, for example insert 1A.

    In K3 i insert the date of initialize a payment for example insert 27/02/2004

    In cell E3 insert a quantity of years payment, insert 5 (is possible to insert only 1,2,3,4,5, in the cell F3 is present
    a symple formulas to calculate the quantity of month)

    This operation make a index code in R3 of sheet ANAGRAFE.

    I could want calculate, with a macro, the residual payment in the cells J3 this mode:

    Insert in A7 of sheet "60" (because the payment is in 60 month) the value in I3, in this mode the sheet
    "60" autocalculate the plain for this amount.

    After this operation find the relative value in column L of sheet "60" from a vlookup refered from the value in R3 of ANAGRAFE
    (find form the column B:L of sheet "60" - column B is the index and column L is the result of residual amount - in this case is 12.500,00)


    End the macro process when in the cells of cloumn I is blank.

    Important is to make a vlookup after the data in I is inserted in A7 of relative sheet)

    If you want delete my formulas in the various cloumn for your convenience.

    The interess for all type of payment is fixed 1n 2,25%

    Associate a little button to run the macro

    If i dont be clear i m here! Tks for all.

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VLOOKUP MULTIPLE (excel 2000)

    This thread has been locked because it is a duplicate of <post#=338229>post 338229</post#> on the Excel Board. All replies to that thread please.
    Gre

Posting Permissions

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