Getting data by calling out date

J

Jafferi

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
 
C

Conan Kelly

Jafferi,

Using the example you provided, in cell P12, enter the following formula:

=SUMPRODUCT((A1:D1=O12)*(A2:D2))

HTH,

Conan Kelly
 
J

Jacob Skaria

In P12 enter

=HLOOKUP(P1,$A$1:$D$2,2)

I have considered only 4 columns. If have you more values towards the right
adjust the $D in the formula to suit your requirements..

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Data from One Spreadsheet to Another ?????? 5
Date/Time 1
Adding A Date To Adjacent Cell 2
Date lists 3
Calculating new date by entering number of additional workdays 1
Automate date & time entry 1
How do I get the current date to autofill 4
Static current date based on when data in another column was enter 3

Top