Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to look for value in a row depending on unknown value?
I use Excel 2002 and I'm looking for a formula that will look to a specific
cell in a row of cells based on a value that comes from part of this formula. I don't have a specific heading, like looking up the word "apples" in a range and then returning the value below that, as the "Lookup Fomulas" require. I'd like to creat a formula that will look to a row of cells, say N67 thru DE67(or whatever row I need it to look at), and then based on a function in an earlier part of this formula, tells it to go to the 7th cell,8th cell,9th cell,etc.. in that row. For example, To say it in words- Whatever the value is in O67 go to that numbered cell starting at N67 and return that value. So if O67=8 then it would return the value that is in the 8th cell of that row or the value that is in cell U67. If anybody can give me some help on this I would greatly appreciate it. Thanks, pcsski |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to look for value in a row depending on unknown value?
Try something like =INDEX(P67:DE67,O67) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=535328 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to look for value in a row depending on unknown value?
daddylonglegs, Thanks for your help. The "INDEX" formula worked.
pcsski "daddylonglegs" wrote: Try something like =INDEX(P67:DE67,O67) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=535328 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |