| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP
Hi all
I have this in u112 =VLOOKUP(0,U10:U110,1) With the intention of finding the the first number above zero, STARTING FROM U110 AND SEARCHING THROUGH U10 and displaying THE RESULT, IF ANY, in U112 DOES NOT WORK HELP |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP
If you were starting at U10 and looking down through U110, you could use this
formula: =INDEX(U10:U110,MATCH(1,((ISNUMBER(U10:U110))*(U10 :U1100)),0)) But since you want to start at U110 and look up through U10, you could use this formula: =LOOKUP(2,1/(ISNUMBER(U10:U110)*(U10:U1100)),U10:U110) Both of these are array formulas. Hit ctrl-shift-enter instead of enter. If you do it correctly, excel will wrap curly brackets {} around your formula. (don't type them yourself.) Adjust the range to match--but you can only use the whole column in xl2007. stew wrote: Hi all I have this in u112 =VLOOKUP(0,U10:U110,1) With the intention of finding the the first number above zero, STARTING FROM U110 AND SEARCHING THROUGH U10 and displaying THE RESULT, IF ANY, in U112 DOES NOT WORK HELP -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP
=INDEX(U10:U100,MATCH(TRUE,U10:U1000,0))
This is an array formula that must be entered with CNTRL-SHFT-ENTER and not just the ENTER key. -- Gary''s Student - gsnu200810 "stew" wrote: Hi all I have this in u112 =VLOOKUP(0,U10:U110,1) With the intention of finding the the first number above zero, STARTING FROM U110 AND SEARCHING THROUGH U10 and displaying THE RESULT, IF ANY, in U112 DOES NOT WORK HELP |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP
First argument of VLOOKUP has to evaluate to a value, it can not be a conditon.
Type or paste this in U112 =INDIRECT("U"&MATCH("Yes",IF(U10:U1100,"Yes",""), 0)) and press CTRL-SHIFT-ENTER together. "stew" wrote: Hi all I have this in u112 =VLOOKUP(0,U10:U110,1) With the intention of finding the the first number above zero, STARTING FROM U110 AND SEARCHING THROUGH U10 and displaying THE RESULT, IF ANY, in U112 DOES NOT WORK HELP |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP
Again thanks to all for your help stew "Dave Peterson" wrote: If you were starting at U10 and looking down through U110, you could use this formula: =INDEX(U10:U110,MATCH(1,((ISNUMBER(U10:U110))*(U10 :U1100)),0)) But since you want to start at U110 and look up through U10, you could use this formula: =LOOKUP(2,1/(ISNUMBER(U10:U110)*(U10:U1100)),U10:U110) Both of these are array formulas. Hit ctrl-shift-enter instead of enter. If you do it correctly, excel will wrap curly brackets {} around your formula. (don't type them yourself.) Adjust the range to match--but you can only use the whole column in xl2007. stew wrote: Hi all I have this in u112 =VLOOKUP(0,U10:U110,1) With the intention of finding the the first number above zero, STARTING FROM U110 AND SEARCHING THROUGH U10 and displaying THE RESULT, IF ANY, in U112 DOES NOT WORK HELP -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
