| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
lookup function
I have a genral question regarding the vlookup function. I have noticed that
there are some vlookup fromulas that have a the lookup array that is 1/(condition) for examlpe: =LOOKUP(2,1/(-B11:K11<0),B11:K11), could someone please explain to me why the array is 1/ divided by the condition? I truly would appreciate it. Thanks in Advance. Nikki |
|
#2
|
|||
|
|||
|
Have a look at Aladin's explanation in the following thread...
http://www.mrexcel.com/board2/viewto...ys=0&postorder =asc&start=0 In article , "Nikki" wrote: I have a genral question regarding the vlookup function. I have noticed that there are some vlookup fromulas that have a the lookup array that is 1/(condition) for examlpe: =LOOKUP(2,1/(-B11:K11<0),B11:K11), could someone please explain to me why the array is 1/ divided by the condition? I truly would appreciate it. Thanks in Advance. Nikki |
|
#3
|
|||
|
|||
|
I have never seen something like this. does the lookup work? if so what data
would be in B11:k11 and what does it respond? "Nikki" wrote: I have a genral question regarding the vlookup function. I have noticed that there are some vlookup fromulas that have a the lookup array that is 1/(condition) for examlpe: =LOOKUP(2,1/(-B11:K11<0),B11:K11), could someone please explain to me why the array is 1/ divided by the condition? I truly would appreciate it. Thanks in Advance. Nikki |
|
#4
|
|||
|
|||
|
Thank you so much Domenic. That answers my question.
"Domenic" wrote: Have a look at Aladin's explanation in the following thread... http://www.mrexcel.com/board2/viewto...ys=0&postorder =asc&start=0 In article , "Nikki" wrote: I have a genral question regarding the vlookup function. I have noticed that there are some vlookup fromulas that have a the lookup array that is 1/(condition) for examlpe: =LOOKUP(2,1/(-B11:K11<0),B11:K11), could someone please explain to me why the array is 1/ divided by the condition? I truly would appreciate it. Thanks in Advance. Nikki |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Function help | Excel Discussion (Misc queries) | |||
| Lookup Function Problems | Excel Worksheet Functions | |||
| Complicated lookup function | Excel Worksheet Functions | |||
| lookup function 1 | Excel Worksheet Functions | |||
| How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions | |||
Linear Mode
