aravindhan_31
Well-known Member
- Joined
- Apr 11, 2006
- Messages
- 672
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi,
Not sure if this will be confusing.
I have Salary data in sheet 1. Col A Emp Id and Col B Salaries
Id Salary
1 289750
2 290617
3 293696
4 293696
5 294941
6 30135
7 305000
8 305913
9 305913
10 307762
11 310464
12 317089
In sheet 2 I have Revised Salary
Amount
290000
298700
313635
329317
345783
363072
381225
400287
420301
441316
463382
486551
in Sheet 1 col C i want to bring these amounts for each employees, since I do not have data in sheet 2 at employee level I cant do a lookup. Instead what i need is
Check Salary of each employee against this range in Sheet 2, and see the diff if difference is between + or - 2%, then bring that amount to those employees. eg
for Emp Id 1 to 5, the salary I would enter Revised salary of 290000 and the reason is, the difference between old salary and revised salary is + or - 2% as shown below.
Old Salary Revised %
289750 290000 0.09%
290617 290000 -0.21%
293696 290000 -1.26%
293696 290000 -1.26%
294941 290000 -1.68%
301235 298700 -0.84%
305000 307661 0.87%
305913 307661 0.57%
305913 307661 0.57%
307762 307661 -0.03%
310464 307661 -0.90%
317089 316891 -0.06%
I have employee list of 600000 and 10000 rows of revised input amounts.
Either macro or formula will help. Thanks in advance
Not sure if this will be confusing.
I have Salary data in sheet 1. Col A Emp Id and Col B Salaries
Id Salary
1 289750
2 290617
3 293696
4 293696
5 294941
6 30135
7 305000
8 305913
9 305913
10 307762
11 310464
12 317089
In sheet 2 I have Revised Salary
Amount
290000
298700
313635
329317
345783
363072
381225
400287
420301
441316
463382
486551
in Sheet 1 col C i want to bring these amounts for each employees, since I do not have data in sheet 2 at employee level I cant do a lookup. Instead what i need is
Check Salary of each employee against this range in Sheet 2, and see the diff if difference is between + or - 2%, then bring that amount to those employees. eg
for Emp Id 1 to 5, the salary I would enter Revised salary of 290000 and the reason is, the difference between old salary and revised salary is + or - 2% as shown below.
Old Salary Revised %
289750 290000 0.09%
290617 290000 -0.21%
293696 290000 -1.26%
293696 290000 -1.26%
294941 290000 -1.68%
301235 298700 -0.84%
305000 307661 0.87%
305913 307661 0.57%
305913 307661 0.57%
307762 307661 -0.03%
310464 307661 -0.90%
317089 316891 -0.06%
I have employee list of 600000 and 10000 rows of revised input amounts.
Either macro or formula will help. Thanks in advance
Last edited: