I'm trying to find out the Emp Id using it's name as explained at :- https://www.exceldemy.com/types-of-lookup-in-excel/, but it is generating some wrong values... I'm using MS Office 2007 for this...
For Ex -:
As shown in the table above the Emp Id for Kevin is 303 and 423 for James, but...