I want to create an array in a single cell and use that as a lookup. I
thought I'd found exactly what I need on Chip Pearson's site which describes
precisely what I'm trying to do but when I follow the instrucions my lookup
formula results in #REF!

If I try and enter the array with Ctrl-Shft-Enter I get the "the formula you
typed contains an error " message.

I'm confused! I must be missing something really obvious. The info from
Chip Pearson's site is below. I'd be grateful for an idiot's guide on
exactly how to get this to work.

Thanks a lot


----------------
........create a define name called "Grades" which refers to the array:

={0,"F";60,"D";70,"C";80,"B";90,"A"}

Then, use VLOOKUP to convert the number to the grade:

=VLOOKUP(A1,Grades,2)

where A1 is the cell contains the numeric value.