Return value based on information in chart

[Rportz]

[TABLE="width: 500"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Anderson
[/TD]
[TD]1074
[/TD]
[TD]1261
[/TD]
[TD]1329
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Camp[/TD]
[TD]1118
[/TD]
[TD]1313
[/TD]
[TD]1384
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]Gregg
[/TD]
[TD]1079
[/TD]
[TD]1268
[/TD]
[TD]1336
[/TD]
[/TR]
</tbody>[/TABLE]


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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Enter County
[/TD]
[TD]Anderson
[/TD]
[/TR]
[TR]
[TD]Enter Number
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Cell Returns:
[/TD]
[TD]1074
[/TD]
[/TR]
</tbody>[/TABLE]


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]

[TABLE="width: 485"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]County[/TD]
[TD="colspan: 5"]Number of Persons in Family[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Anderson [/TD]
[TD]1,074.00[/TD]
[TD]1,261.00[/TD]
[TD]1,329.00[/TD]
[TD]1,482.00[/TD]
[TD]1,506.00[/TD]
[/TR]
[TR]
[TD]Camp [/TD]
[TD]1,118.00[/TD]
[TD]1,313.00[/TD]
[TD]1,384.00[/TD]
[TD]1,543.00[/TD]
[TD]1,568.00[/TD]
[/TR]
[TR]
[TD]Cherokee [/TD]
[TD]1,079.00[/TD]
[TD]1,268.00[/TD]
[TD]1,336.00[/TD]
[TD]1,490.00[/TD]
[TD]1,514.00[/TD]
[/TR]
[TR]
[TD]Gregg [/TD]
[TD]1,218.00[/TD]
[TD]1,430.00[/TD]
[TD]1,507.00[/TD]
[TD]1,680.00[/TD]
[TD]1,707.00[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 254"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 2"]County of Residence:[/TD]
[TD]Camp[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Household Size:[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Cell Returns:[/TD]
[TD] $ 1,384.00 [/TD]
[/TR]
</tbody>[/TABLE]

 

[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?

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD="align: right"]Household Size:
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Anderson
[/TD]
[TD]1,074[/TD]
[TD]1,261[/TD]
[TD]1,329[/TD]
[TD]1,482[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Camp
[/TD]
[TD]1,118
[/TD]
[TD]1,313
[/TD]
[TD]1,384
[/TD]
[TD]1,543
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]Cherokee
[/TD]
[TD]1,079
[/TD]
[TD]1,268
[/TD]
[TD]1,490
[/TD]
[TD]1,514
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]Gregg
[/TD]
[TD]1,218
[/TD]
[TD]1,430
[/TD]
[TD]1,507
[/TD]
[TD]1,707
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]User Enters a County (from above)
[/TD]
[TD]Camp
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]User Enters Household size (from row 1)
[/TD]
[TD]2
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]Cell returns the data based on county & household size that is entered:
[/TD]
[TD]1,313
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I hope this is makes sense.

 

[Fluff]

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