help needed in VLOOKUP function
 

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 suppose
to get ( A-) but i got an error. and the rest of the function works very
good.


I'm waiting your help very soon.


Thanks:)


--
DaredEvil590
------------------------------------------------------------------------
DaredEvil590's Profile: http://www.excelforum.com/member.php...o&userid=29085
View this thread: http://www.excelforum.com/showthread...hreadid=488202

help needed in VLOOKUP function
 

Hi

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

Andy.

"DaredEvil590"
wrote in message
news:DaredEvil590.1z2aha_1132937403.3712@excelforu m-nospam.com...

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 suppose
to get ( A-) but i got an error. and the rest of the function works very
good.


I'm waiting your help very soon.


Thanks:)


--
DaredEvil590
------------------------------------------------------------------------
DaredEvil590's Profile:
http://www.excelforum.com/member.php...o&userid=29085
View this thread: http://www.excelforum.com/showthread...hreadid=488202

help needed in VLOOKUP function
 

You did avoid the line wrap didn't you?

--

HTH

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


"DaredEvil590"
wrote in message
news:DaredEvil590.1z2aha_1132937403.3712@excelforu m-nospam.com...

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 suppose
to get ( A-) but i got an error. and the rest of the function works very
good.


I'm waiting your help very soon.


Thanks:)


--
DaredEvil590
------------------------------------------------------------------------
DaredEvil590's Profile:
http://www.excelforum.com/member.php...o&userid=29085
View this thread: http://www.excelforum.com/showthread...hreadid=488202