Help with IF Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a range of data (C16:N22), with row names in A16:A22 & column headings in C15:N15; there is 1 column for each month of the year. I want to reference a particular month in B2 & have that month's info. be automatically pulled into B3:B9.

I thought the formula =IF(B2=C15:N15,C16:N16,"") would work, but it returns #VALUE!

Can anyone help? Thanks in advance!
 
I have a range of data (C16:N22), with row names in A16:A22 & column headings in C15:N15; there is 1 column for each month of the year. I want to reference a particular month in B2 & have that month's info. be automatically pulled into B3:B9.

I thought the formula =IF(B2=C15:N15,C16:N16,"") would work, but it returns #VALUE!

Can anyone help? Thanks in advance!
Click to expand...


In B3 put the formula:

=HLOOKUP($B$2,$C$15:$N$22,ROW()-1,FALSE)

and copy/drag down to B9


--ron
 
Back
Top