Is it possible to enter a number in one cell and have a different cell populate with a set value corresponding with the number?

How can I make it so that when I input a number into Worksheet 1, cell B1(#household members), B2 updates with the corresponding number from Worksheet 1, column B1. 

Is this possible?  

Worksheet 1

  A B
1 # Household Members Input # people
2 Income Limit for HH Limit for #people in “C1”

Sheet 2

1 #People HH Size Limit
2 1-Person $69,500
3 2-Person $79,400
2 3-Person $89,300




By: Amber

Leave a Reply

Your email address will not be published. Required fields are marked *