View Single Post
  #1   Report Post  
Carole O
 
Posts: n/a
Default Index table lookup anomaly

I have a spreadsheet with a table lookup. This is the formula I use:
=INDEX('PRODUCT TABLE'!$E$2:$M$146,MATCH(L23,'PRODUCT TABLE'!$E$2:$E$145,0),9)

It returns a correct response (or 0) for every lookup except MR! If I
change the L23 cell to MP I get the correct response for MP. If I change it
back to MR, I get #N/A. I have changed the Product Table cells for MR -
brought the cell above (MP) down to the MR cell and changed it to MR, added
and deleted the other lookup fields in the table hoping to get a response -
nothing. I've deleted the MR rows and added them back in - nothing.

Any ideas besides changing the MR code to something else? I don't want to
do that since the MR is the logical code to use.

Thanks,

Carole O