referencing a cell based on date

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)
 
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
 
Back
Top