# Suggestion on this one?

1. ## Suggestion on this one?

I've got an Excel File that contains 2 sheets,

One one sheet I have cells that list the QTY and Price of our products. On
the 2nd sheet I have different prices listed for each product, depending on
the area of the state that the customer is located. ie:

Product 1 Zone 1 Zone 2 Zone 3
1 Wigets 25.00 45.00 55.00
2 Wigets 30.00 50.00 60.00

This is what I'm trying to do. On the 1st sheet I want to be able to type
in one cell that says "Zone". If I type 1 and in the QTY cell type 2 then
the price would show 55.00 (as per sheet 2).

Does that make sense?

Thanks,

2. ## Re: Suggestion on this one?

=INDEX(Sheet2!A1:D100,MATCH("Zone
1",Sheet2!\$A\$1:\$D\$1,0),MATCH(2,Sheet2!\$A1:\$A100,0))

although I get 30?

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Dale Meredith" <DaleMeredith@discussions.microsoft.com> wrote in message
news:755D036C-89C5-4F1B-BA60-55C9A04F8DB4@microsoft.com...
> I've got an Excel File that contains 2 sheets,
>
> One one sheet I have cells that list the QTY and Price of our products.

On
> the 2nd sheet I have different prices listed for each product, depending

on
> the area of the state that the customer is located. ie:
>
> Product 1 Zone 1 Zone 2 Zone 3
> 1 Wigets 25.00 45.00 55.00
> 2 Wigets 30.00 50.00 60.00
>
> This is what I'm trying to do. On the 1st sheet I want to be able to type
> in one cell that says "Zone". If I type 1 and in the QTY cell type 2 then
> the price would show 55.00 (as per sheet 2).
>
> Does that make sense?
>
> Thanks,

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1