I have Cells of Data
Name Date
1 | Jerry | |
2 | billy | | _________
3 | | | |____2_____| This cell is called "Key"
4 | | |
5 | | |
6 | | |
The colom with the numbers is called "Reff" the "Name" at the top is "Name" and the colome with the "Date" at the top is "Date"
Now I have some other cells with fomulas in them "=Lookup(Key,reff,name)
What is suposed to do is serch the "reff" Colum find "2" (as shown in Cell "Key" and retunr the value in the "Name Column'' in this Case "Billy" and when you change the number in "Key" cell it would continue to work the same way.
Now I have used this funtion 100s of times in the past and for soome reason this time it does not work.
any help on this would be helpful.
Thanks
Name Date
1 | Jerry | |
2 | billy | | _________
3 | | | |____2_____| This cell is called "Key"
4 | | |
5 | | |
6 | | |
The colom with the numbers is called "Reff" the "Name" at the top is "Name" and the colome with the "Date" at the top is "Date"
Now I have some other cells with fomulas in them "=Lookup(Key,reff,name)
What is suposed to do is serch the "reff" Colum find "2" (as shown in Cell "Key" and retunr the value in the "Name Column'' in this Case "Billy" and when you change the number in "Key" cell it would continue to work the same way.
Now I have used this funtion 100s of times in the past and for soome reason this time it does not work.
any help on this would be helpful.
Thanks