Index/Match returning unwanted data

scadaman29325

New Member
Joined
Oct 13, 2002
Messages
23
I'm getting more than I wanted. If there is no match, I would like nothing returned.

Using this from Office support:
=INDEX(array or reference, MATCH(lookup_value,lookup_array,[match_type])


I think this is right, it gives me the value I want. The function is in cell M18. I want to copy it to M2 to M11122.
=INDEX(MetNotes!$C$1:$C$625,MATCH(A17,$A$1:$A$11122,0))
=Index(Table to be referenced for the result I want,MATCH(item to be looked up, table of items to be looked up, exact match))

The problem is that when I copy down this function, I get a value and I should not, because there is no match. I'm getting the same value as the preceding cell.
This is what I have in M18
=INDEX(MetNotes!$C$1:$C$625,MATCH(A18,$A$1:$A$11122,0))
There should be no match for the data in A18 and I want M18 to be blank.

Any help would be APPRECIATED! TIA, Phil.
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Forum statistics

Threads
1,215,772
Messages
6,126,801
Members
449,337
Latest member
BBV123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top