Using lookup to find todays data and display in different worksheet

[Steve]

Dear all

I am trying to write a formula.What I need is:

On sheet 1 column A I have a list of dates (for next 2 years). With
varying data in column C E G & J.

On sheet 2 A1 I want it to lookup for todays date and display the data
from the corrosponding row from colmn C, in A2 I want data from E, A3
data from G and A4 data from J.

On sheet 2 Row 2 I want the same but for tomorrow.

and again Row 3 for the next day.

Help I have tried lots of variations but with my limited knowledge
can't solve it!

All the best

Steve

 

[Guest]

Hi Steve:

You need to use the vlookup.

on sheet 2:

[A1] =today()
[B1?]=vlookup($A1,'Sheet 1'!$A:$J,3,false)
[C1?]=vlookup($A1,'Sheet 1'!$A:$J,5,false)
[D1?]=vlookup($A1,'Sheet 1'!$A:$J,7,false)
[E1?]=vlookup($A1,'Sheet 1'!$A:$J,10,false)

[A2] =A1+1
[A3] =A2+1
Copy b1:e1 down to rows row 2 and 3.


I assume you meant the columns across and not down for the first row.

check your names of the sheets generally they arre called sheet1 and sheet2
not sheet 1 and sheet 2. adjust as required.

 

[Steve]

Hi Steve:

You need to use the vlookup.

on sheet 2:

[A1] =today()
[B1?]=vlookup($A1,'Sheet 1'!$A:$J,3,false)
[C1?]=vlookup($A1,'Sheet 1'!$A:$J,5,false)
[D1?]=vlookup($A1,'Sheet 1'!$A:$J,7,false)
[E1?]=vlookup($A1,'Sheet 1'!$A:$J,10,false)

[A2] =A1+1
[A3] =A2+1
Copy b1:e1 down to rows row 2 and 3.

I assume you meant the columns across and not down for the first row.

check your names of the sheets generally they arre called sheet1 and sheet2
not sheet 1 and sheet 2. adjust as required.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.

Dear all

I am trying to write a formula.What I need is:

On sheet 1 column A I have a list of dates (for next 2 years). With
varying data in column C E G & J.

On sheet 2 A1 I want it to lookup for todays date and display the data
from the corrosponding row from colmn C, in A2 I want data from E, A3
data from G and A4 data from J.

On sheet 2 Row 2 I want the same but for tomorrow.

and again Row 3 for the next day.

Help I have tried lots of variations but with my limited knowledge
can't solve it!

All the best

Steve- Hide quoted text -

- Show quoted text -

Works great! Many thanks. Don't understand it, but that's why I was
stuck and you could help. Yet again someone from this group saved me
sitting here for hours and hour!

Many Many thanks.

Steve

 

[Steve]

I have worked out the formula I need with your help.

However how do I stop it returning a 0 when no data is present in the
cell?

My formula:

=VLOOKUP($G37,Staffing!$C:$AL,36,FALSE)

Many thanks

Steve

 

[Guest]

Try:

=if(VLOOKUP($G37,Staffing!$C:$AL,36,FALSE)=0,"",
VLOOKUP($G37,Staffing!$C:$AL,36,FALSE))