How to retrieve data from a table

How to retrieve data from a table

Post by R1JL » Fri, 19 Jun 2009 02:44:01


I have built a Table (sheet 1) that includes 7 columns (A 鈥?G) and 11 rows
with the first row being titles. The titles in order are # of Users; Code 1;
Monthly Pmt; Code 2; 3 Pmts; Code 3; and Annual Pmt. Under #of users, I have
numbers 1 鈥?10 in numerical order. Under Code 1 the number, 1 is in each
cell. Under Monthly Pmt, there is a dollar value in descending order. Under
Code 2, the number 2 is in each cell. Under 3 Pmts there is a dollar value
in descending order. Under Code 3, the number 3 is in each cell. Under
Annual Pmt, there is a dollar value in descending order.

On sheet 2 there are six columns (A 鈥?F), the titles in order are Date;
Code; Customer Pay Type; Customer Name; Number of Users; and Sales Price Per
User. The titles Code and Number of Users are input cells. In the Code cell
I would input a 1 (Monthly Pmt), 2 (3 Pmts), or 3 (Annual Pmt). In the
Number of Users cell I would input a 1, 2, 3, 4, 5, 6, 7, 8, 9, or 10.


I need a solution for the Sales Price Per User using (matching) the Code and
Number of Users on the Table (sheet 1).

Thank you in advance for helping me.

--
GRK
 
 
 

How to retrieve data from a table

Post by Bassman6 » Fri, 19 Jun 2009 07:16:34

Please stay within the original thread. If your question is misunderstood,
try restating it rather than starting another thread.

With your table on Sheet1 beginning with "USERS" in cell A1 (data in
A2:G11), Sheet2 "Code" in Col B and "#of Users" in Col E.
Place this standard formula in Sheet2!F2 and copy down as needed.
=INDEX(Sheet1!$A$2:$G$11,Sheet2!E2,(Sheet2!B2*2)+1)

Best Regards,
Dave