transferring data from one sheet to another via changing date

  • Thread starter Thread starter Colin Threlfall
  • Start date Start date
C

Colin Threlfall

I don't know if this is the correct group to ask this
question but here goes.
I have sheet1 with dates in one row and beneath each date
I have a set of 16 figures. On sheet2 I have a table that
converts these figures into relevant data. What I am
after is a formula that if I enter a date into my table
on sheet2 all 16 figures from sheet1 underneath the
corresponding date will be entered into a similer column
in my table. Is this possible? I have limited knowledge
of excel and am learning daily! Many thanks in advance.
 
With your desired date in Cell B4 on sheet2 enter:
=HLOOKUP(B$4,Sheet1!$B$5:$D$21,ROW()-3,FALSE)
and copy down. << and even across if you need multiples>>

$B$5:$D$21 on Sheet1 is the Table-Range of your data including the date
header.

HTH
 
Back
Top