Hello Excel people,
I'm trying to merge data about schools across several different spreadsheets using INDEX and MATCH.
In the attached example, I'm trying to look up a DFES number (Column B) using the formula:
=INDEX('URN lookup'!$D$2:$D$1461,MATCH(L2,'URN lookup'!$K$2:$K$1461,0))
It isn't working, and I can't work out why.
I'll also need to merge other data - including a URN for each school and about another 15 columns in total. Hopefully with a bit of a prompt I'll be able to work that out on my own!
Any and all help much appreciated.
Thanks,
Philip
Bookmarks