Formula that populates column with data from other columns, using user input

[Genesis09]

Hey there!

I'm new to Chandoo, and I'm stuck on a formula that I can't wrap my mind around atm. I've attached an Excel file - it's a portion of a bigger spreadsheet. Basically, what I'm trying to do is:

- A user would input a date into cell A2; IF that date matches one of the dates at the top of columns C through N, the data under the matching date would populate in column B (after cell B5). So, if a user inputs 9/30/2014 into cell A2, the data under the matching date (which, in this case, is in column C) would then populate into column B.

It looks like I'll need functions in column B to make this happen, and the function might need to reference a few ranges - I'm not sure though! If anyone has any suggestions, I'm all ears. Thanks!

 

[Asheesh]

Hi Genesis09 -

First of all welcome to the forum..

Please see the attached..hope this helps..

Formula used in column B is - INDEX($C$5:$N$105,,MATCH($A$2,$C$4:$N$4,0))

 

[Somendra Misra]

Hi,

Another option can be using HLOOKUP in column B. Try below formula in B5 and copy down:

=HLOOKUP($A$2,$C$4:$N$105,ROWS(B$4:B5),0)

Regards,