IF x 12
 

wow !!

i have 1 row `A` with 12 columns, each one has one month of year. And the
row ´B´ i have each value for each month.
and i have in cell b15 with a list of each month where i can choose only one.

i´d like to choose 1 month in b15 and return the respective value of the
group A1:b12 for cell b17.

how can i do this?

i could do that if excel could use 12 nested ´IF` .
thanks

IF x 12
 

HI Igor

Sounds like a job for HLOOKUP:

=HLOOKUP(B15,$A$1:$B$12,2,0)

typed into B17.

Hope this helps, and a Merry Christmas to you & yours!

Richard


igor wrote:
wow !!

i have 1 row `A` with 12 columns, each one has one month of year. And the
row ´B´ i have each value for each month.
and i have in cell b15 with a list of each month where i can choose only one.

i´d like to choose 1 month in b15 and return the respective value of the
group A1:b12 for cell b17.

how can i do this?

i could do that if excel could use 12 nested ´IF` .
thanks

IF x 12
 

You talk about "Row" A. If you mean column A with months in A1:A12 and values
in B1:B12 then that's a VLOOKUP

=VLOOKUP(B15,$A$1:$B$12,2,0)

"RichardSchollar" wrote:

HI Igor

Sounds like a job for HLOOKUP:

=HLOOKUP(B15,$A$1:$B$12,2,0)

typed into B17.

Hope this helps, and a Merry Christmas to you & yours!

Richard


igor wrote:
wow !!

i have 1 row `A` with 12 columns, each one has one month of year. And the
row ´B´ i have each value for each month.
and i have in cell b15 with a list of each month where i can choose only one.

i´d like to choose 1 month in b15 and return the respective value of the
group A1:b12 for cell b17.

how can i do this?

i could do that if excel could use 12 nested ´IF` .
thanks