Return list of values

[creator007]

Hello Mr. Excel Forum Members,

This seems easy but I can't figure it out. I have a list of dollar sales for several divisions and the divisions are listed by numbers. I want to be able to input the division number and the list of sales will populate. Can you please help?

<table border="0" cellpadding="0" cellspacing="0" width="559"><col style="mso-width-source:userset;mso-width-alt:6070;width:125pt" width="166"> <col style="width:48pt" span="2" width="64"> <col style="mso-width-source:userset;mso-width-alt:3218;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:2523;width:52pt" width="69"> <col style="mso-width-source:userset;mso-width-alt:1974; width:41pt" span="2" width="54"> <tbody><tr style="height:12.75pt" height="17"> <td style="height:12.75pt;width:125pt" height="17" width="166">
</td> <td style="width:48pt" width="64">
</td> <td style="width:48pt" width="64">
</td> <td style="width:66pt" width="88">Division (data)</td> <td style="width:52pt" width="69">
</td> <td style="width:41pt" width="54">
</td> <td style="width:41pt" width="54">
</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Divison (Input division here)</td> <td class="xl67"> </td> <td>
</td> <td class="xl66">1</td> <td class="xl66">2</td> <td class="xl66">3</td> <td class="xl66">4</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">
</td> <td>
</td> <td>
</td> <td class="xl65"> $ 50.00 </td> <td class="xl65"> $ 12.00 </td> <td class="xl65"> $ 1.00 </td> <td class="xl65"> $50.00 </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">
</td> <td>
</td> <td>
</td> <td class="xl65"> $ 25.00 </td> <td class="xl65"> $ 50.00 </td> <td class="xl65"> $50.00 </td> <td class="xl65"> $50.00 </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">
</td> <td>
</td> <td>
</td> <td class="xl65"> $ 50.00 </td> <td class="xl65"> $ 50.00 </td> <td class="xl65"> $16.00 </td> <td class="xl65"> $50.00 </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">
</td> <td>
</td> <td>
</td> <td class="xl65"> $ 22.00 </td> <td class="xl65"> $ 18.00 </td> <td class="xl65"> $50.00 </td> <td class="xl65"> $33.00 </td> </tr> </tbody></table>

 

[creator007]

Here's how the table looks like


-- removed inline image ---

 

[John Davis]

Hello Mr. Excel Forum Members,

This seems easy but I can't figure it out. I have a list of dollar sales for several divisions and the divisions are listed by numbers. I want to be able to input the division number and the list of sales will populate. Can you please help?

<table border="0" cellpadding="0" cellspacing="0" width="559"><col style="mso-width-source:userset;mso-width-alt:6070;width:125pt" width="166"> <col style="width:48pt" span="2" width="64"> <col style="mso-width-source:userset;mso-width-alt:3218;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:2523;width:52pt" width="69"> <col style="mso-width-source:userset;mso-width-alt:1974; width:41pt" span="2" width="54"> <tbody><tr style="height:12.75pt" height="17"> <td style="height:12.75pt;width:125pt" height="17" width="166">
</td> <td style="width:48pt" width="64">
</td> <td style="width:48pt" width="64">
</td> <td style="width:66pt" width="88">Division (data)</td> <td style="width:52pt" width="69">
</td> <td style="width:41pt" width="54">
</td> <td style="width:41pt" width="54">
</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Divison (Input division here)</td> <td class="xl67"> </td> <td>
</td> <td class="xl66">1</td> <td class="xl66">2</td> <td class="xl66">3</td> <td class="xl66">4</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">
</td> <td>
</td> <td>
</td> <td class="xl65"> $ 50.00 </td> <td class="xl65"> $ 12.00 </td> <td class="xl65"> $ 1.00 </td> <td class="xl65"> $50.00 </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">
</td> <td>
</td> <td>
</td> <td class="xl65"> $ 25.00 </td> <td class="xl65"> $ 50.00 </td> <td class="xl65"> $50.00 </td> <td class="xl65"> $50.00 </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">
</td> <td>
</td> <td>
</td> <td class="xl65"> $ 50.00 </td> <td class="xl65"> $ 50.00 </td> <td class="xl65"> $16.00 </td> <td class="xl65"> $50.00 </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">
</td> <td>
</td> <td>
</td> <td class="xl65"> $ 22.00 </td> <td class="xl65"> $ 18.00 </td> <td class="xl65"> $50.00 </td> <td class="xl65"> $33.00 </td> </tr> </tbody></table>

Does this help?

Division   Output
3	3	1	2	3	4
	1	$50.00 	$12.00 	$1.00 	$50.00 
	50	$25.00 	$50.00 	$50.00 	$50.00 
	16	$50.00 	$50.00 	$16.00 	$50.00 
	50	$22.00 	$18.00 	$50.00 	$33.00

Column A1 you'd place the division number. Column B1 Formula Copied down.


=HLOOKUP(A$1,$C$1:$F$5,ROW(),FALSE)

 

[creator007]

Thank you, John!

 

[John Davis]

Thank you, John!

You're welcome. Glad it helped.