Thread: IF x 12
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Igor Igor is offline
external usenet poster
 
Posts: 20
Default 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