referencing a cell based on date

[Guest]

H

New to this so please be patient. (appreciate your help). I am trying to reference a number from one worksheet based on the date. For example, if the current date is april 9 on one worksheet, then I want the referenced row (value) on that date from another worksheet to be returned

Example

Worsheet

April 9, 200

Apples

Orange

Worksheet

Date Apples Orange
April 9 2

I am looking for a formula that will automatically update the number of apples and oranges in the 1st worksheet based on date on first worksheet

Hope this makes sense

Thank you for your help

 

[Frank Kabel]

Hi
if your date i stored in cell A1 use
=VLOOKUP(A1,'worksheet2'!$A$1:$C$10,2,0)
and
=VLOOKUP(A1,'worksheet2'!$A$1:$C$10,3,0)

 

[Guest]

Thanks Frank..will try that. I very much appreciate your help

----- Frank Kabel wrote: ----

H
if your date i stored in cell A1 us
=VLOOKUP(A1,'worksheet2'!$A$1:$C$10,2,0
an
=VLOOKUP(A1,'worksheet2'!$A$1:$C$10,3,0

-
Regard
Frank Kabe
Frankfurt, German


Ellen Thomson wrote