Posted to microsoft.public.excel.worksheet.functions

Jerry

external usenet poster

Posts: 142

vlookup error even though data available

I have the following function
=LOOKUP(F11,{"A+","B+","C+","D+","A-","B-","C-","D-","A","B","C","D","F"},{100,85,70,55,90,75,60,45,9 5,80,65,50,40})
and when say cell F11 = A it returns #N/A even though the equivalent should
be 90 or if F11 = B or B- returns 100, is there anything wrong with this
formula. Thanks in advance

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VLOOKUP Error	evoxfan	Excel Discussion (Misc queries)	4	July 10th 09 03:57 AM
Error of slope taking into account error of the data points	cer144	Excel Worksheet Functions	5	July 7th 08 07:26 PM
vlookup error	[email protected]	Excel Worksheet Functions	5	May 31st 07 02:52 PM
vlookup error	Vlookup not accurate	Excel Discussion (Misc queries)	0	October 4th 06 06:21 PM
VLookup N/A Error	WandaSG	Excel Discussion (Misc queries)	5	December 12th 05 07:48 PM

All times are GMT +1. The time now is 01:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us