Hi Team ,
Please Help as while copying this formula in different cells i am getting same result i.e. for " abhishek Mishra" for reference see the below photo
May be because of 'Manual' calculation you are getting same data.
Please check below and ensure that calculation option is selected as 'Automatic'.
File --> Options --> Formula --> Calculation options --> Automatic.
It's the same formula with copy/pasting, thus same result