Candyland25
New Member
- Joined
- Dec 2, 2016
- Messages
- 33
[FONT="]Hello,
Try to write a formula with if and vlookup and I think I got it to work but I'm having trouble making to work for a entire year I need.[/FONT]
[FONT="]Example:
Sheet 1
October November
Names Hours Hours
John Smith 25 15
Katie Wilson 45 55
Jeremy Pate 37 20[/FONT]
[FONT="]Sheet 2
October
Names Hours
John Smith
Katie Wilson
Jeremy Pate[/FONT]
[FONT="]=IF($B$1='Sheet1'!$B$1,VLOOKUP(A1,'Sheet1'!A:K,2,0),"no")[/FONT]
[FONT="]With this formula if B1(October) is in sheet1 than it matches and the formula shows me the hours for month of October.
However for month of November unless I change the formula I can't get the hours to appear in Sheet 2. Sheet 2 has ONLY one column for hours and I can't add anymore due to reporting restrictions. I can change B1 cell from October to November. How do I get excel to automatically update it self if change "B1" Cell from October to November.[/FONT]
[FONT="]Please help. Thank you[/FONT]
Try to write a formula with if and vlookup and I think I got it to work but I'm having trouble making to work for a entire year I need.[/FONT]
[FONT="]Example:
Sheet 1
October November
Names Hours Hours
John Smith 25 15
Katie Wilson 45 55
Jeremy Pate 37 20[/FONT]
[FONT="]Sheet 2
October
Names Hours
John Smith
Katie Wilson
Jeremy Pate[/FONT]
[FONT="]=IF($B$1='Sheet1'!$B$1,VLOOKUP(A1,'Sheet1'!A:K,2,0),"no")[/FONT]
[FONT="]With this formula if B1(October) is in sheet1 than it matches and the formula shows me the hours for month of October.
However for month of November unless I change the formula I can't get the hours to appear in Sheet 2. Sheet 2 has ONLY one column for hours and I can't add anymore due to reporting restrictions. I can change B1 cell from October to November. How do I get excel to automatically update it self if change "B1" Cell from October to November.[/FONT]
[FONT="]Please help. Thank you[/FONT]