If and Vlookup with automatic update for yearly forecast

[Candyland25]

[FONT=&quot]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=&quot]Example:
Sheet 1
October November
Names Hours Hours
John Smith 25 15
Katie Wilson 45 55
Jeremy Pate 37 20[/FONT]
[FONT=&quot]Sheet 2
October
Names Hours
John Smith
Katie Wilson
Jeremy Pate[/FONT]
[FONT=&quot]=IF($B$1='Sheet1'!$B$1,VLOOKUP(A1,'Sheet1'!A:K,2,0),"no")[/FONT]
[FONT=&quot]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=&quot]Please help. Thank you[/FONT]

 

[texasalynn]

try this

	November
Names	Hours
John Smith	15
Katie Wilson	55
Jeremy Pate	20

<tbody>
</tbody>

formula: =HLOOKUP($B$1,Sheet1!B:C,MATCH(A3,Sheet1!A:A,0),0)