LinkBack URL
About LinkBacks
Hi,
Please find enclosed sheet and column AC in tab wageresigter. Here I am directly referencing EmployeeMaster!L2
Instead, I need to match the ID in both the tabs and then get value of L2.
How can I achieve this ?
Hi,
Please find enclosed sheet and column AC in tab wageresigter. Here I am directly referencing EmployeeMaster!L2
Instead, I need to match the ID in both the tabs and then get value of L2.
How can I achieve this ?
Original formula in AC2:
=IF(EmployeeMaster!K2="Y",IF(SUM(W4:AB4)>SUM(P4:U4),0,IF(SUM(P4:U4)>CalculationBasics!$B$5,CalculationBasics!$B$5*CalculationBasics!$B$6%,SUM(P4:U4)*CalculationBasics!$B$6%)),0)
New formula suggestion:
=IF(VLOOKUP($B4, EmployeeMaster!$A:$K, 11, 0)="Y",IF(SUM(W4:AB4)>SUM(P4:U4),0,IF(SUM(P4:U4)>CalculationBasics!$B$5,CalculationBasics!$B$5*CalculationBasics!$B$6%,SUM(P4:U4)*CalculationBasics!$B$6%)),0)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Originally Posted by JBeaucaire
It is working. Thank You
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks