aryanaveen
Board Regular
- Joined
- Jan 5, 2015
- Messages
- 104
Hi Guys,
can someone please help me in building a right lookup up formula
can someone please help me in building a right lookup up formula
A | B | C | D | ||
1 | Id | Name | Birth date | Age | |
2 | 55 | ABC | 14-Aug-20 | 25 | |
3 | 55 | ABC | 14-Jul-20 | 34 | |
4 | 55 | ABC | 14-Jun-20 | 33 | |
5 | 22 | FF | 24-May-20 | 22 | |
6 | 33 | SS | 10-Sep-20 | 15 | |
7 | 33 | SS | 5-Aug-20 | 20 | |
8 | |||||
9 | |||||
10 | What I am looking for is | ||||
11 | |||||
12 | Id | Name | Birth date | Age | |
13 | 55 | ABC | 14-Jun-20 | Need formula which will give me age based on ID and birth date | |
14 | 33 | SS | 5-Aug-20 |