I have a worksheet with information and I want to grab another piece of information from another sheet.
In the Data sheet, the names are in a certain order, and I used the index match function to lookup the name in the lookup sheet in the data sheet, but I am getting wrong values.
I am using this formula:
Can someone please help me?
Thanks in advance.
In the Data sheet, the names are in a certain order, and I used the index match function to lookup the name in the lookup sheet in the data sheet, but I am getting wrong values.
I am using this formula:
Code:
[HTML]=INDEX(Data!B:B,MATCH(Lookup!A3,Lookup!A:A,0))[/HTML]
Thanks in advance.