Thread: LOOKUP function not returning expected value - Using vector_lookup format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JerichoForce
 
Posts: n/a
Default LOOKUP function not returning expected value - Using vector_lookup format

Hi

I am running this lookup function but can't get the correct result,
anyone know what I am doing wrong

=LOOKUP(AI61,{"NearExactExactExact","ExactNearExac tExact","ExactNearExactDifferent","ExactDifferentE xactExact","ExactDifferentExactDifferent","ExactAb sentExactExact","ExactAbsentExactDifferent","Exact ExactExactExact","ExactExactExactDifferent","NearE xactExactDifferent",90,93,97},{"A4","A1","A2","A2" ,"A3","A2","A3","A1","A2","A3","A-","A","A+"})

value in AI61 is NearExactExactExact, but it is returning A-, I was
expecting it to return A4?


--
JerichoForce
------------------------------------------------------------------------
JerichoForce's Profile: http://www.excelforum.com/member.php...o&userid=33584
View this thread: http://www.excelforum.com/showthread...hreadid=533623

Reply With QuoteReply With Quote