Right, here is my formula
=VLOOKUP(Y2,A:B,1,FALSE)
A B X Y Z
1 ID Name Name Code
2 111 A #N/A E XXX
3 222 B #N/A C UUU
4 333 C #N/A D GGG
5 444 D #N/A B BBB
6 555 E #N/A A NNN
I want to match the ID of column A, with the name located in columns B&Y - but each time I enter the formula above - it just returns 'N/A'.
To my mind's eye - this formula looks right & I can't work out what is wrong!
Any ideas?
Thanks
K
Bookmarks