Hi
I have this problem
A1
Ar Th Math res chem mater draw e1 inf top hy ws draws
45 70 80 55 60 70 80 46 70 80 57 70 80 45 55 46 57
46 57 4 3 3
I have data from a1 to m1
in n2 min of a2 to c2
in o2 min of d2 to g2
in p2 min of h2 to j2
in q2 min of k2 to m2
in r2 this formula IF(N2P2;N2;P2)
in s2 this formula IF(O2Q2;O2;Q2)
in t2 this formula 50-R2
in u2 this formula 60-S2
in v2 this formula IF(T2U2;U2;T2)
in w2 tis formula IF(V2=3;LOOKUP(S2;A2:M2;C1:M1)) which give math which
is not correct, is this because lookup wants the data in ascending
order, I can not put in this order any help
Thank you all in advance
Regards
Jam

If you put your "Header" row at the bottom of the data, rather than at the
top, and use HLOOKUP with the FALSE option instead of LOOKUP, you should be
able to achieve the returns you seek...........although, in case of
duplicates, you will only receive a return for the first occurance.

Vaya con Dios,
Chuck, CABGx3



"jam" wrote in message
ups.com...
Hi
I have this problem
A1
Ar Th Math res chem mater draw e1 inf top hy ws draws
45 70 80 55 60 70 80 46 70 80 57 70 80 45 55 46 57
46 57 4 3 3
I have data from a1 to m1
in n2 min of a2 to c2
in o2 min of d2 to g2
in p2 min of h2 to j2
in q2 min of k2 to m2
in r2 this formula IF(N2P2;N2;P2)
in s2 this formula IF(O2Q2;O2;Q2)
in t2 this formula 50-R2
in u2 this formula 60-S2
in v2 this formula IF(T2U2;U2;T2)
in w2 tis formula IF(V2=3;LOOKUP(S2;A2:M2;C1:M1)) which give math which
is not correct, is this because lookup wants the data in ascending
order, I can not put in this order any help
Thank you all in advance
Regards
Jam

I think your ranges should be the same size, why C1:M1 and A2:M2?
Regardless perhaps this sort of arrangement....

IF(V2=3;INDEX(A1:M1;MATCH(S2;A2:M2;0)))

btw you could simplify formulas such as

=IF(N2P2;N2;P2)

to

=MAX(N2;P2)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=557560

Thank you Daddylonglegs
A2 and M2 is typing error
The problem is beautifully solved
Regards
Jam
daddylonglegs wrote:
I think your ranges should be the same size, why C1:M1 and A2:M2?
Regardless perhaps this sort of arrangement....

IF(V2=3;INDEX(A1:M1;MATCH(S2;A2:M2;0)))

btw you could simplify formulas such as

=IF(N2P2;N2;P2)

to

=MAX(N2;P2)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=557560