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 -:
![1700110648127.jpeg 1700110648127.jpeg](https://exceldemy.com/forum/data/attachments/1/1020-113df8fe016bd86fb70d9d376f58b1f3.jpg?hash=ET34_gFr2G)
As shown in the table above the Emp Id for Kevin is 303 and 423 for James, but after applying the LOOKUP formula it gives the same value for both of them, which is not right.
![1700111280165.png 1700111280165.png](https://exceldemy.com/forum/data/attachments/1/1021-e80b3430b648f08e765e552b36e69864.jpg?hash=6As0MLZI8I)
The formula is also mentioned in the attached Excel sheet...
For Ex -:
![1700110648127.jpeg 1700110648127.jpeg](https://exceldemy.com/forum/data/attachments/1/1020-113df8fe016bd86fb70d9d376f58b1f3.jpg?hash=ET34_gFr2G)
As shown in the table above the Emp Id for Kevin is 303 and 423 for James, but after applying the LOOKUP formula it gives the same value for both of them, which is not right.
![1700111280165.png 1700111280165.png](https://exceldemy.com/forum/data/attachments/1/1021-e80b3430b648f08e765e552b36e69864.jpg?hash=6As0MLZI8I)
The formula is also mentioned in the attached Excel sheet...
Attachments
Last edited: