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

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

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