help needed in VLOOKUP function

[DaredEvil590]

HI everyone

I have a small error in this formula:

=VLOOKUP(E48,{0,"F";60,"D";70,"C-";73,"C";76,"C+";80,"B-";83,"B";86,"B+";90,"
A-";95,"A"},2)

the error occures when i enter a value between ( 90-95) which I suppos
to get ( A-) but i got an error. and the rest of the function works ver
good.


I'm waiting your help very soon.


Thanks:

 

[Guest]

Hi

You don't say what the error is. Anyway, the formula works fine for me
(Excel 2000).

Andy.

"DaredEvil590" <[email protected]>
wrote in message
news[email protected]...

 

[Bob Phillips]

You did avoid the line wrap didn't you?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DaredEvil590" <[email protected]>
wrote in message
news[email protected]...