Looking up two values
 

I have a spreadsheet that needs to look up a numerical value first and then
go to the month that we are closing e.g. February and apply the value in the
cell that is on the row first looked up. I have tried to do a vlookup nested
with an hlookup but can not get the formula right to make it work for
anything other than January data. Thanks for your help.

See

http://www.contextures.com/xlFunctions03.html


--

Regards,

Peo Sjoblom



"Dumbfounded in Denver" <Dumbfounded in
wrote in message ...
I have a spreadsheet that needs to look up a numerical value first and
then
go to the month that we are closing e.g. February and apply the value in
the
cell that is on the row first looked up. I have tried to do a vlookup
nested
with an hlookup but can not get the formula right to make it work for
anything other than January data. Thanks for your help.

Perfect!! Thanks - problem solved.

"Peo Sjoblom" wrote:

See

http://www.contextures.com/xlFunctions03.html


--

Regards,

Peo Sjoblom



"Dumbfounded in Denver" <Dumbfounded in
wrote in message ...
I have a spreadsheet that needs to look up a numerical value first and
then
go to the month that we are closing e.g. February and apply the value in
the
cell that is on the row first looked up. I have tried to do a vlookup
nested
with an hlookup but can not get the formula right to make it work for
anything other than January data. Thanks for your help.