INDEX AND MATCH - what am I doing wrong?

**strangecharm** · 04-05-2021, 08:43 AM

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

**Fluff13** · 04-05-2021, 08:50 AM

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.

**AliGW** · 04-05-2021, 08:52 AM

Leading spaces!

Try this:

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

**strangecharm** · 04-05-2021, 09:16 AM

Argh! Thanks!

**Fluff13** · 04-05-2021, 09:17 AM

Glad to help & thanks for the feedback.

**AliGW** · 04-05-2021, 09:28 AM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

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.

INDEX AND MATCH - what am I doing wrong?

LinkBack

Thread Tools

Rate This Thread

Display

INDEX AND MATCH - what am I doing wrong?

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

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

Index Match (wrong result)

Index/Match wrong?

[SOLVED] =INDEX($N$3:$Q$100,MATCH(1,($A$2=$N$2:$N$100)*($B$2=$Q$2:$Q$100),0)) what wrong

[SOLVED] Index/Match wrong result

[SOLVED] Row and column match? (IF INDEX MATCH) What am I doing wrong.

[SOLVED] Index Match Question - What am I doing wrong?

Index and Match-wrong value

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions