Index & Match - not working on merged cells

I am trying to use Index & Match function in cell - C23. What it does is look for the value in cells - D31 to D35 for ' Cisco 881W' and should return the quantity value in cell - C23. It is giving me a #N/A error. Is it due to the range I am looking up is composed of merged cells? I am attaching the file for consideration and will appreciate a fix to it please.

*I want the quantity value for a specific item which can be within cell range - D31 to D35 displayed in cell - C23 when the option 'Cisco 881w' is selected

Regards,

Hi,

I thing the "don't use this feature" is the appropriate statement on
http://www.officearticles.com/excel/...soft_excel.htm

So here is how I see merged cells:
Say you have B1 and B2 merged.
You try to do a VLookup("Bob",B1:B5.....).
Should Vlookup look in B2 for your value as it is now merged???

Unmerge cells in your workbook and start over, is my best advice.

well
=INDEX(C31:C35,MATCH(U13,D31:I35),0)

D31:I35 is wrong for match it would have to be
D31:D35
even tho'cells are merged that is the actual range
but
=INDEX(C31:C35,MATCH(U13,D31:D35),0)
why u13?

What cells are merged?

Merged cells cause more problems than they are worth, avoid using/remove if at all possible