Hi
yes, you had spaces in these fields :-)
--
Regards
Frank Kabel
Frankfurt, Germany
"Carole O" schrieb im Newsbeitrag
...
Hi, Frank -
Here's an update. I inserted 3 lines above MP, moved MP to the new
lines,
re-entered MR, and deleted the MR lines. Guess what - it works!!
There must
have been an unprintable character in those lines.
Thanks again for your interest and help.
Carole
"Frank Kabel" wrote:
Hi
frank[dot]kabel[at]freenet[dot]de
--
Regards
Frank Kabel
Frankfurt, Germany
"Carole O" schrieb im
Newsbeitrag
...
Frank -
I have a file all ready for you - what is your e-mail address?
Carole
"Frank Kabel" wrote:
Hi
if you like email me your file with the non-working formula
--
Regards
Frank Kabel
Frankfurt, Germany
"Carole O" schrieb im
Newsbeitrag
...
Thanks Frank for your help. Here is part of the table I'm
using
(it
stretches to one row (A - M)
CODE CATEGORY PPR DESCRIPTION PC COLOR/SIDE Press Sheet
Size STOCK BLEED UP # ITEMS BINDERY IND STD SHEETS/PKG UNIT
CAT 2-MAKE READY MP Make new plates MP
CORP 2-MAKE READY MP Make new plates MP
CUST 2-MAKE READY MP Make new plates MP
CAT 2-MAKE READY MR Make Ready MR
CORP 2-MAKE READY MR Make Ready MR
CUST 2-MAKE READY MR Make Ready MR
"Frank Kabel" wrote:
Hi
and there're no blanks in your lookup table for the 'MR'
value?
--
Regards
Frank Kabel
Frankfurt, Germany
"Carole O" schrieb im
Newsbeitrag
...
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