Syntax pb

[AciD]

hi,

i have this formulas =MATCH(P14;H:H;0) which gives me 107 and this formulas =MATCH(R14;H:H;0) which gives me 131.

All i want is something like =MATCH(Q14;H107:H131;0)

but =MATCH(Q14;HMATCH(P14;H:H;0):HMATCH(R14;H:H;0);0) doesn't work, obvious syntax pb, but i've tried all generic character i know, i haven't found any solutions to concatenate the formulas

thx.

[Yogi Anand]

On 2002-05-03 18:20, AciD wrote:
hi,

i have this formulas =MATCH(P14;H:H;0) which gives me 107 and this formulas =MATCH(R14;H:H;0) which gives me 131.

All i want is something like =MATCH(Q14;H107:H131;0)

but =MATCH(Q14;HMATCH(P14;H:H;0):HMATCH(R14;H:H;0);0) doesn't work, obvious syntax pb, but i've tried all generic character i know, i haven't found any solutions to concatenate the formulas

thx.

When you are using =match(P14,H:H,0)
the result 107 means that P14 matches entry in the 107th row of column H;
similarly when you have =match(Q14,H:H,0)
the result 131 means that Q14 matches entry in the 131st row of column H.

I don't understand what you mean by
=match(Q14,H107:H131) does not work

If Q14 is =P14, the above formula will result in 1,
and if Q14 is =R14, the above formula will result in 25.

and regarding your formula:
=MATCH(Q14;HMATCH(P14;H:H;0):HMATCH(R14;H:H;0);0)

I don't understand the makeup of this formula -- neither the logic nor the syntax of this formula.

Hope This Helps!

_________________
Yogi Anand

Edit: Deleted inactive website from hardcoded signature

[ This Message was edited by: Yogi Anand on 2003-01-19 13:26 ]

[AciD]

In fact, i need to obtain this kind of formula : =MATCH(Q14,H107:H131;0)

as 2 others formulas gimme the numbers 107 and 131, i was wondering how concatenate the letter "H" followed by the 2 formulas results..

Taht's why in theory i would want to write :
=MATCH(Q14;HMATCH(P14;H:H;0):HMATCH(R14;H:H;0);0) instead of =MATCH(Q14,H107:H131;0)

Hope this time i'm more clear

[Aladin Akyurek]

On 2002-05-04 05:36, AciD wrote:
In fact, i need to obtain this kind of formula : =MATCH(Q14,H107:H131;0)

as 2 others formulas gimme the numbers 107 and 131, i was wondering how concatenate the letter "H" followed by the 2 formulas results..

Taht's why in theory i would want to write :
=MATCH(Q14;HMATCH(P14;H:H;0):HMATCH(R14;H:H;0);0) instead of =MATCH(Q14,H107:H131;0)

Hope this time i'm more clear

This is more like Excelese .

Does this

=MATCH(Q14,OFFSET($H$1,MATCH(P14,H:H,0)-1,0,MATCH(R14,H:H,0)-MATCH(P14,H:H,0)+1,1),0)

meet your needs?

[AciD]

!!!

Thx !!

=MATCH(Q14;OFFSET($H$1;MATCH(P14;H:H;0)-1;0;MATCH(R14;H:H;0)-MATCH(P14;H:H;0)+1;1);0)

is working perfectly !!

Thousand Thank you

[James]

My day would not be complete, if i didn't see
Aladin step up to the plate and hit another
home run.

James