0

I'm working with excel 2010,

I have an excel sheet with two tables. The primary table contains a calender and each calender day has a specific numeric value in the cell below the date.

The numeric values of the second table are entirely dependant of the value of its master cell which is H 18. So the only important cell here is H18. Above cell H18 is another cell (F13) containing another date.

enter image description here

The goal is to be able to change the date in cell F13 and that the data belonging to this date written in the calender will be copied automatically into cell H18.

4
  • What have you attempted so far? Did you get stuck with something?
    – Dave
    Feb 17, 2014 at 14:14
  • I have tried the research formula, but I'm not really sure how to apply this here...
    – Julio
    Feb 17, 2014 at 14:17
  • 1
    Can you add the formula you've found to your post please
    – Dave
    Feb 17, 2014 at 14:18
  • I did not find a specific formula yet. Thank you for any effort.
    – Julio
    Feb 17, 2014 at 14:46

1 Answer 1

1

Use a HLOOKUP

H18 =HLOOKUP($F$13,$D$6:$Q$7,2,0)

Change the D6:Q7 to wherever your first table ends.

4
  • Thank you! My table ends at AG so my formula would be =HLOOKUP($F$13,$D$6:$AG$7,2,0) But it does not seem toaccept it...can you see a mistake?
    – Julio
    Feb 17, 2014 at 15:01
  • =HLOOKUP($F$13,$D$6:$Q$7,2,1) Got it! THANKS A MILLION!!!
    – Julio
    Feb 17, 2014 at 15:03
  • Using a 1 at the end is like using a true and it will not always look for the exact value. The 0 false is a better method Feb 17, 2014 at 15:07
  • That's right! Thx!
    – Julio
    Feb 17, 2014 at 15:17

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .