Thread
:
LOOKUP function not returning expected value - Using vector_lookup format
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
paul
Posts: n/a
LOOKUP function not returning expected value - Using vector_lookup
if you use the fourth argument as false vlookup will look for an exact
match..and you dont need to sort
=VLOOKUP(AI61,{"NearExactExactExact","A4";"ExactNe arExactExact","A1";"ExactNearExactDifferent","A2"; "ExactDifferentExactExact","A2";"ExactDifferentExa ctDifferent","A3";"ExactAbsentExactExact","A2";"Ex actAbsentExactDifferent","A3";"ExactExactExactExac t","A1";"ExactExactExactDifferent","A2";"NearExact ExactDifferent","A3";90,"A-";93,"A";97,"A+"},2,false)
--
paul
remove nospam for email addy!
"JerichoForce" wrote:
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 Quote