Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP function not returning expected value - Using vector_lookup format
Try this instead
=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,0) LOOKUP needs to have the lookup vector sorted in ascending order -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "JerichoForce" wrote in message news:JerichoForce.26fxob_1145331308.0442@excelforu m-nospam.com... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Don't understand Lookup function | New Users to Excel | |||
LOOKUP FUNCTION | Excel Worksheet Functions | |||
Help using lookup function | Excel Discussion (Misc queries) | |||
lookup function 1 | Excel Worksheet Functions | |||
Lookup function returning reference, not value | Excel Worksheet Functions |