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

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)),"")

Two conditions - multiple Sheets and multiple columns

bixha said:

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.

Click to expand...

See whether it corresponds this idea
The formula used INDIRECT function and VLOOKUP functions

In cell C24 put this formula
In cell G24 put this formula

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

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

Thank you for your support , fixed my problem now thanks