Annalise19
New Member
- Joined
- Nov 2, 2016
- Messages
- 8
I have a list of names and want to find each person's designation from a database, but LOOKUP won't give me the correct value 
This is my formula: =LOOKUP(A1646,A3:A3514,I3:I3514)
Col A - Name
Col I - Designation
Please note that the names are not repeated. How could I make it right?

This is my formula: =LOOKUP(A1646,A3:A3514,I3:I3514)
Col A - Name
Col I - Designation
Please note that the names are not repeated. How could I make it right?