ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Different range (https://www.excelbanter.com/excel-discussion-misc-queries/238446-different-range.html)

puiuluipui
Different range
 
Hi, i need to modify a little bit this formula :
{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59}. If i enter a
number in cell "E58" the formula to look in column "S" and if i enter another
number to look in column "T".

If in "E58" is "10.000" than the formula to be identical and to look in
"S5:S24".
{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59}

If in "E58" is "15.000" than the formula to look in "T5:T24".
{=MIN(IF(T5:T24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59}

Can this be done?
Thanks!

Eduardo
Different range
 
Hi,
=if(E58=10000,{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59},if(E58=15000,{=MIN(IF(T 5:T24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59})

if this helps please click yes, thanks

"puiuluipui" wrote:

Hi, i need to modify a little bit this formula :
{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59}. If i enter a
number in cell "E58" the formula to look in column "S" and if i enter another
number to look in column "T".

If in "E58" is "10.000" than the formula to be identical and to look in
"S5:S24".
{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59}

If in "E58" is "15.000" than the formula to look in "T5:T24".
{=MIN(IF(T5:T24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59}

Can this be done?
Thanks!

puiuluipui
Different range
 
Hi, i cant make your code work. My code is an array code and must be entered
with crtl+shift and enter. That's why i have those brackets. I tried the same
with your code, but is not working. What am i doing wrong?
Thanks!

"Eduardo" a scris:

Hi,
=if(E58=10000,{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59},if(E58=15000,{=MIN(IF(T 5:T24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59})

if this helps please click yes, thanks

"puiuluipui" wrote:

Hi, i need to modify a little bit this formula :
{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59}. If i enter a
number in cell "E58" the formula to look in column "S" and if i enter another
number to look in column "T".

If in "E58" is "10.000" than the formula to be identical and to look in
"S5:S24".
{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59}

If in "E58" is "15.000" than the formula to look in "T5:T24".
{=MIN(IF(T5:T24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59}

Can this be done?
Thanks!

Eduardo
Different range
 
Hi,
try

=IF(E58=10000,MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59,IF(E58=15000,MIN(IF(T5:T 24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59))

press shift+ctrl+enter

"puiuluipui" wrote:

Hi, i cant make your code work. My code is an array code and must be entered
with crtl+shift and enter. That's why i have those brackets. I tried the same
with your code, but is not working. What am i doing wrong?
Thanks!

"Eduardo" a scris:

Hi,
=if(E58=10000,{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59},if(E58=15000,{=MIN(IF(T 5:T24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59})

if this helps please click yes, thanks

"puiuluipui" wrote:

Hi, i need to modify a little bit this formula :
{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59}. If i enter a
number in cell "E58" the formula to look in column "S" and if i enter another
number to look in column "T".

If in "E58" is "10.000" than the formula to be identical and to look in
"S5:S24".
{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59}

If in "E58" is "15.000" than the formula to look in "T5:T24".
{=MIN(IF(T5:T24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59}

Can this be done?
Thanks!

puiuluipui
Different range
 
WORKS GREAT!!
Thanks allot!

"Eduardo" a scris:

Hi,
try

=IF(E58=10000,MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59,IF(E58=15000,MIN(IF(T5:T 24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59))

press shift+ctrl+enter

"puiuluipui" wrote:

Hi, i cant make your code work. My code is an array code and must be entered
with crtl+shift and enter. That's why i have those brackets. I tried the same
with your code, but is not working. What am i doing wrong?
Thanks!

"Eduardo" a scris:

Hi,
=if(E58=10000,{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59},if(E58=15000,{=MIN(IF(T 5:T24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59})

if this helps please click yes, thanks

"puiuluipui" wrote:

Hi, i need to modify a little bit this formula :
{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59}. If i enter a
number in cell "E58" the formula to look in column "S" and if i enter another
number to look in column "T".

If in "E58" is "10.000" than the formula to be identical and to look in
"S5:S24".
{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59}

If in "E58" is "15.000" than the formula to look in "T5:T24".
{=MIN(IF(T5:T24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59}

Can this be done?
Thanks!

puiuluipui
Different range
 
Hi, can you make this formula work the same way?
=VLOOKUP(E61, U5:U24, 2, FALSE)

If in "E58" is 10.000 than the formula to look in "U5:U24"
If in "E58" is 15.000 than the formula to look in "V5:V24"

"Eduardo" a scris:

Hi,
try

=IF(E58=10000,MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59,IF(E58=15000,MIN(IF(T5:T 24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59))

press shift+ctrl+enter

"puiuluipui" wrote:

Hi, i cant make your code work. My code is an array code and must be entered
with crtl+shift and enter. That's why i have those brackets. I tried the same
with your code, but is not working. What am i doing wrong?
Thanks!

"Eduardo" a scris:

Hi,
=if(E58=10000,{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59},if(E58=15000,{=MIN(IF(T 5:T24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59})

if this helps please click yes, thanks

"puiuluipui" wrote:

Hi, i need to modify a little bit this formula :
{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59}. If i enter a
number in cell "E58" the formula to look in column "S" and if i enter another
number to look in column "T".

If in "E58" is "10.000" than the formula to be identical and to look in
"S5:S24".
{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59}

If in "E58" is "15.000" than the formula to look in "T5:T24".
{=MIN(IF(T5:T24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59}

Can this be done?
Thanks!

Eduardo
Different range
 
Hi,
=if(e58=10000,VLOOKUP(E61, U5:U24, 2, FALSE),if(e58=15000,VLOOKUP(E61,
v5:v24, 2, FALSE)))

"puiuluipui" wrote:

Hi, can you make this formula work the same way?
=VLOOKUP(E61, U5:U24, 2, FALSE)

If in "E58" is 10.000 than the formula to look in "U5:U24"
If in "E58" is 15.000 than the formula to look in "V5:V24"

"Eduardo" a scris:

Hi,
try

=IF(E58=10000,MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59,IF(E58=15000,MIN(IF(T5:T 24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59))

press shift+ctrl+enter

"puiuluipui" wrote:

Hi, i cant make your code work. My code is an array code and must be entered
with crtl+shift and enter. That's why i have those brackets. I tried the same
with your code, but is not working. What am i doing wrong?
Thanks!

"Eduardo" a scris:

Hi,
=if(E58=10000,{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59},if(E58=15000,{=MIN(IF(T 5:T24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59})

if this helps please click yes, thanks

"puiuluipui" wrote:

Hi, i need to modify a little bit this formula :
{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59}. If i enter a
number in cell "E58" the formula to look in column "S" and if i enter another
number to look in column "T".

If in "E58" is "10.000" than the formula to be identical and to look in
"S5:S24".
{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59}

If in "E58" is "15.000" than the formula to look in "T5:T24".
{=MIN(IF(T5:T24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59}

Can this be done?
Thanks!

puiuluipui
Different range
 
Hi, i misstype the code. Sorry. So,...

....can you make this formula work the same way?
=VLOOKUP(E61, U4:V24, 2, FALSE)

If in "E58" is 10.000 than the formula to look in "S4:T24"
If in "E58" is 15.000 than the formula to look in "U4:V24"

Can this work with vlookup?

Thanks!!








"puiuluipui" a scris:

Hi, can you make this formula work the same way?
=VLOOKUP(E61, U5:U24, 2, FALSE)

If in "E58" is 10.000 than the formula to look in "U5:U24"
If in "E58" is 15.000 than the formula to look in "V5:V24"

"Eduardo" a scris:

Hi,
try

=IF(E58=10000,MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59,IF(E58=15000,MIN(IF(T5:T 24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59))

press shift+ctrl+enter

"puiuluipui" wrote:

Hi, i cant make your code work. My code is an array code and must be entered
with crtl+shift and enter. That's why i have those brackets. I tried the same
with your code, but is not working. What am i doing wrong?
Thanks!

"Eduardo" a scris:

Hi,
=if(E58=10000,{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59},if(E58=15000,{=MIN(IF(T 5:T24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59})

if this helps please click yes, thanks

"puiuluipui" wrote:

Hi, i need to modify a little bit this formula :
{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59}. If i enter a
number in cell "E58" the formula to look in column "S" and if i enter another
number to look in column "T".

If in "E58" is "10.000" than the formula to be identical and to look in
"S5:S24".
{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59}

If in "E58" is "15.000" than the formula to look in "T5:T24".
{=MIN(IF(T5:T24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59}

Can this be done?
Thanks!

Eduardo
Different range
 
Hi
=if(e58=10000,VLOOKUP(E61, s5:t24, 2, FALSE),if(e58=15000,VLOOKUP(E61,
u5:v24, 2, FALSE)))


"puiuluipui" wrote:

Hi, i misstype the code. Sorry. So,...

....can you make this formula work the same way?
=VLOOKUP(E61, U4:V24, 2, FALSE)

If in "E58" is 10.000 than the formula to look in "S4:T24"
If in "E58" is 15.000 than the formula to look in "U4:V24"

Can this work with vlookup?

Thanks!!








"puiuluipui" a scris:

Hi, can you make this formula work the same way?
=VLOOKUP(E61, U5:U24, 2, FALSE)

If in "E58" is 10.000 than the formula to look in "U5:U24"
If in "E58" is 15.000 than the formula to look in "V5:V24"

"Eduardo" a scris:

Hi,
try

=IF(E58=10000,MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59,IF(E58=15000,MIN(IF(T5:T 24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59))

press shift+ctrl+enter

"puiuluipui" wrote:

Hi, i cant make your code work. My code is an array code and must be entered
with crtl+shift and enter. That's why i have those brackets. I tried the same
with your code, but is not working. What am i doing wrong?
Thanks!

"Eduardo" a scris:

Hi,
=if(E58=10000,{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59},if(E58=15000,{=MIN(IF(T 5:T24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59})

if this helps please click yes, thanks

"puiuluipui" wrote:

Hi, i need to modify a little bit this formula :
{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59}. If i enter a
number in cell "E58" the formula to look in column "S" and if i enter another
number to look in column "T".

If in "E58" is "10.000" than the formula to be identical and to look in
"S5:S24".
{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59}

If in "E58" is "15.000" than the formula to look in "T5:T24".
{=MIN(IF(T5:T24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59}

Can this be done?
Thanks!

puiuluipui
Different range
 

Works great!
Thanks!


"Eduardo" a scris:

Hi
=if(e58=10000,VLOOKUP(E61, s5:t24, 2, FALSE),if(e58=15000,VLOOKUP(E61,
u5:v24, 2, FALSE)))


"puiuluipui" wrote:

Hi, i misstype the code. Sorry. So,...

....can you make this formula work the same way?
=VLOOKUP(E61, U4:V24, 2, FALSE)

If in "E58" is 10.000 than the formula to look in "S4:T24"
If in "E58" is 15.000 than the formula to look in "U4:V24"

Can this work with vlookup?

Thanks!!








"puiuluipui" a scris:

Hi, can you make this formula work the same way?
=VLOOKUP(E61, U5:U24, 2, FALSE)

If in "E58" is 10.000 than the formula to look in "U5:U24"
If in "E58" is 15.000 than the formula to look in "V5:V24"

"Eduardo" a scris:

Hi,
try

=IF(E58=10000,MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59,IF(E58=15000,MIN(IF(T5:T 24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59))

press shift+ctrl+enter

"puiuluipui" wrote:

Hi, i cant make your code work. My code is an array code and must be entered
with crtl+shift and enter. That's why i have those brackets. I tried the same
with your code, but is not working. What am i doing wrong?
Thanks!

"Eduardo" a scris:

Hi,
=if(E58=10000,{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59},if(E58=15000,{=MIN(IF(T 5:T24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59})

if this helps please click yes, thanks

"puiuluipui" wrote:

Hi, i need to modify a little bit this formula :
{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59}. If i enter a
number in cell "E58" the formula to look in column "S" and if i enter another
number to look in column "T".

If in "E58" is "10.000" than the formula to be identical and to look in
"S5:S24".
{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59}

If in "E58" is "15.000" than the formula to look in "T5:T24".
{=MIN(IF(T5:T24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59}

Can this be done?
Thanks!


All times are GMT +1. The time now is 06:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com