Remember Me?

#1
November 25th 05, 04:47 PM posted to microsoft.public.excel.worksheet.functions
 DaredEvil590 Posts: n/a
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

#2
November 25th 05, 04:55 PM posted to microsoft.public.excel.worksheet.functions
 Posts: n/a
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[email protected] 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

#3
November 25th 05, 05:06 PM posted to microsoft.public.excel.worksheet.functions
 Bob Phillips Posts: n/a
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[email protected] 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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post JoshuaEyer Excel Worksheet Functions 2 October 15th 05 03:49 PM Barb Reinhardt Excel Worksheet Functions 3 August 26th 05 07:36 PM JohnK Excel Worksheet Functions 6 August 22nd 05 12:52 PM Chris Manning Excel Discussion (Misc queries) 2 June 2nd 05 10:26 PM wuwu Excel Worksheet Functions 2 November 13th 04 01:38 PM

All times are GMT +1. The time now is 05:49 PM.