# INDEX AND MATCH - what am I doing wrong?

1. ## INDEX AND MATCH - what am I doing wrong?

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

2. ## Re: INDEX AND MATCH - what am I doing wrong?

You're postcodes on col L have a space before them, either get rid of the space, or use
Formula:
`Please Login or Register  to view this content.`

3. ## Re: INDEX AND MATCH - what am I doing wrong?

Try this:

=INDEX('URN lookup'!\$D\$2:\$D\$1461,MATCH(TRIM(L2),'URN lookup'!\$K\$2:\$K\$1461,0))

4. ## Re: INDEX AND MATCH - what am I doing wrong?

Argh! Thanks!

5. ## Re: INDEX AND MATCH - what am I doing wrong?

Glad to help & thanks for the feedback.

6. ## Re: INDEX AND MATCH - what am I doing wrong?

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who helped.

There are currently 1 users browsing this thread. (0 members and 1 guests)