Results 1 to 3 of 3

Thread: vlookup-transfer-data-another-sheet-data-emp.

  1. #1
    Seeker bixha's Avatar
    Join Date
    Oct 2015
    Location
    Ferizaj, Kosovo
    Posts
    8
    Articles
    0
    Excel Version
    excel 2010

    vlookup-transfer-data-another-sheet-data-emp.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am trying to data from sheet January etc to show up automatic in the pay stub when I selected Name of Employee and Month am trying with vlookup but is not working can you help out plz see attachment
    I am trayin to use this formual sheet PAYSTUB1 at C24 for Work Order and G24 for Services , but I am not sure in the correct formula.

    =IF((INDIRECT($C$3&"!"&VLOOKUP($H$10,Data!$A$3:$E$15,5,0)&(RIGHT(CELL("address",G24),2)-4)))>0,INDIRECT($C$3&"!"&VLOOKUP($H$10,Data!$A$3:$E$15,5,0)&(RIGHT(CELL("address",G24),2)-4)),"")
    Attached Files Attached Files

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013

    Two conditions - multiple Sheets and multiple columns

    Quote Originally Posted by bixha View Post
    I am trayin to use this formual sheet PAYSTUB1 at C24 for Work Order and G24 for Services , but I am not sure in the correct formula.
    See whether it corresponds this idea
    The formula used INDIRECT function and VLOOKUP functions

    In cell C24 put this formula
    Code:
    =INDIRECT(ADDRESS(ROW(E10);COLUMN(INDIRECT(VLOOKUP($H$10;Data!$A$3:$G$52;4;FALSE)&1));4;1;$C$3))
    In cell G24 put this formula
    Code:
    =INDIRECT(ADDRESS(ROW(E10);COLUMN(INDIRECT(VLOOKUP($H$10;Data!$A$3:$G$52;5;FALSE)&1));4;1;$C$3))
    Formulas are related to Data Sheet depending on the choice in cell C3 and H10 on Sheet 'PAYSTUB-2015'.
    The formula returns the data from a specific column from Row10.
    Copy the formulas down

    Column/Indirect/Vlookup nested formula returns the number of column
    Code:
    COLUMN(INDIRECT(VLOOKUP($H$10;Data!$A$3:$G$52;4;FALSE)&1))
    btw: If you want to see how the formula works look Evaluate Formula

    Note! You may need to use a comma instead of a semicolon as a separator in the formula
    Attached Files Attached Files
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  3. #3
    Seeker bixha's Avatar
    Join Date
    Oct 2015
    Location
    Ferizaj, Kosovo
    Posts
    8
    Articles
    0
    Excel Version
    excel 2010
    Thank you for your support , fixed my problem now thanks

Posting Permissions

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