|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 26th, 2006, 10:55 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
looking for a lookup function
I am trying to find a function that looks for a value in a list and then
return the value 2 cells below in the same colum of a list. What function can I use in order to do that ? Thanks Zak 
|
|
#2
October 26th, 2006, 11:25 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
looking for a lookup function
Try...
=INDEX(A2:A100,MATCH(B2,A2:A100,0)+2) ....where B2 contains the lookup value. Hope this helps! In article , Zak Zak @discussions.microsoft.com wrote: I am trying to find a function that looks for a value in a list and then return the value 2 cells below in the same colum of a list. What function can I use in order to do that ? Thanks Zak
|
|
#3
October 27th, 2006, 12:09 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
looking for a lookup function
Thanks, it did work.
Zak "Domenic" wrote: Try... =INDEX(A2:A100,MATCH(B2,A2:A100,0)+2) ....where B2 contains the lookup value. Hope this helps! In article , Zak Zak @discussions.microsoft.com wrote: I am trying to find a function that looks for a value in a list and then return the value 2 cells below in the same colum of a list. What function can I use in order to do that ? Thanks Zak
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
