Return value based on information in chart

[Rportz]

A	B	C	D	E
1		1	2	3
2	Anderson	1074	1261	1329
3	Camp	1118	1313	1384
4	Gregg	1079	1268	1336

<tbody>
</tbody>

Question:

If user enters the number "1" in a cell and enters "Anderson" in another cell, I want to return 1074 based on the above chart, but if user enters "Camp" in a cell and "2" in another cell, I want the cell to return 1313 and so on...

User enters:

Enter County	Anderson
Enter Number	1
Cell Returns:	1074

<tbody>
</tbody>

Any help that you can provide?

 

[Fluff]

How about

Excel 2013 32 bit
	A	B	C	D	E	F	G	H	I	J
1		1	2	3
2	Anderson	1074	1261	1329					Enter County	Camp
3	Camp	1118	1313	1384					Enter Number	2
4	Gregg	1079	1268	1336					Cell Returns:	1313
Don't delete

Cell Formulas
Range	Formula
J4	=VLOOKUP(J2,A2:D4,J3+1,FALSE)

 

[Rportz]

Thank you so much; however, I've tried using vlookup as you have indicated with no luck.

 

[Fluff]

Where is your data?

 

[Rportz]

County	Number of Persons in Family
	1	2	3	4	5
Anderson	1,074.00	1,261.00	1,329.00	1,482.00	1,506.00
Camp	1,118.00	1,313.00	1,384.00	1,543.00	1,568.00
Cherokee	1,079.00	1,268.00	1,336.00	1,490.00	1,514.00
Gregg	1,218.00	1,430.00	1,507.00	1,680.00	1,707.00

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

County of Residence:	Camp
Household Size:	3
Cell Returns:	$ 1,384.00

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[Fluff]

Where is it in the sheet, ie what rows/columns?
What cells hold camp, 3 & the formula?

 

[Rportz]

Where is it in the sheet, ie what rows/columns?
What cells hold camp, 3 & the formula?

	A	B	C	D	E
1	Household Size:	1	2	3	4
2	Anderson	1,074	1,261	1,329	1,482
3	Camp	1,118	1,313	1,384	1,543
4	Cherokee	1,079	1,268	1,490	1,514
5	Gregg	1,218	1,430	1,507	1,707
6	User Enters a County (from above)	Camp
7	User Enters Household size (from row 1)	2
8	Cell returns the data based on county & household size that is entered:	1,313

<tbody>
</tbody>

I hope this is makes sense.

 

[Fluff]

In that case try
=VLOOKUP(B6,A2:D5,B7+1,FALSE)