View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jafferi[_2_] Jafferi[_2_] is offline
external usenet poster
 
Posts: 22
Default Getting data by calling out date

How can I get a formula that link to a date cell based on the following table.

For example, in column a1 I have date 0201 and in row a2, I have number 41.1.

In cell p12, a formula that can automatically determine by the date I enter
in p11 for example date 0201, P12 will show results as 41.1

date 0201 date 0204 date 0206 date 0209
row 2 41.1 42.5 47.1 39.9