| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cond. Format Data Bars of range based on values of another range | Excel Worksheet Functions | |||
| Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
| Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
| formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Threaded Mode
