Return a price based on a customer from a drop down list

D7 is a dropdown list of customer names. F16 is a drop down list of products.
J16 is where I would like a price to be shown based on the price from another
folder called PartTable. PartTable contains numerous columns. Product ID,
Cntr Size, Cntr Desc, Cost are the first four columns. Next columns E thru V
contain product pricing for 6 customers. Each customer has 3 columns (Colum1
is ea price, Column 2 is Case Price, and Column 3 is GM%).
In a folder called CustTable, in cell C1 the following formula is
used=IF(OriginalInvoicepg1!D7="","",VLOOKUP(OriginalInvoicepg1!D7,CustTable!A:B,2,FALSE))
to identify the customer on "OriginalInvloicepg1" page (D7). My question is
how do I get the cell J16 on "OriginalInvoicepg1" to show the price from the
"PartTable" page. Keeping in mind the Case Pricing columns for the 6
customers are a different amount.
I was given a formula of
=if(custtable!$c$1="",9999999,vlookup(f16,parttable!A:X,custtable!$c$1,false)). I get a #ref! error message on this. Any suggestions?
Pete Elbert. I will be happy to email the spread sheet for a more clear
explanation.

Hi!

I'll take look.

xl can help at comcast period net

Remove "can" and change the obvious.

Biff

"Pete Elbert" <[email protected]> wrote in message
news:[email protected]...
> D7 is a dropdown list of customer names. F16 is a drop down list of
> products.
> J16 is where I would like a price to be shown based on the price from
> another
> folder called PartTable. PartTable contains numerous columns. Product
> ID,
> Cntr Size, Cntr Desc, Cost are the first four columns. Next columns E
> thru V
> contain product pricing for 6 customers. Each customer has 3 columns
> (Colum1
> is ea price, Column 2 is Case Price, and Column 3 is GM%).
> In a folder called CustTable, in cell C1 the following formula is
> used=IF(OriginalInvoicepg1!D7="","",VLOOKUP(OriginalInvoicepg1!D7,CustTable!A:B,2,FALSE))
> to identify the customer on "OriginalInvloicepg1" page (D7). My question
> is
> how do I get the cell J16 on "OriginalInvoicepg1" to show the price from
> the
> "PartTable" page. Keeping in mind the Case Pricing columns for the 6
> customers are a different amount.
> I was given a formula of
> =if(custtable!$c$1="",9999999,vlookup(f16,parttable!A:X,custtable!$c$1,false)).
> I get a #ref! error message on this. Any suggestions?
> Pete Elbert. I will be happy to email the spread sheet for a more clear
> explanation.

How do I get in touch (email) you. I tried several times based on your email
listed and I keep getting it sent back. Thanks again. My best email address
is [email protected]

"Biff" wrote:

> Hi!
>
> I'll take look.
>
> xl can help at comcast period net
>
> Remove "can" and change the obvious.
>
> Biff
>
> "Pete Elbert" <[email protected]> wrote in message
> news:[email protected]...
> > D7 is a dropdown list of customer names. F16 is a drop down list of
> > products.
> > J16 is where I would like a price to be shown based on the price from
> > another
> > folder called PartTable. PartTable contains numerous columns. Product
> > ID,
> > Cntr Size, Cntr Desc, Cost are the first four columns. Next columns E
> > thru V
> > contain product pricing for 6 customers. Each customer has 3 columns
> > (Colum1
> > is ea price, Column 2 is Case Price, and Column 3 is GM%).
> > In a folder called CustTable, in cell C1 the following formula is
> > used=IF(OriginalInvoicepg1!D7="","",VLOOKUP(OriginalInvoicepg1!D7,CustTable!A:B,2,FALSE))
> > to identify the customer on "OriginalInvloicepg1" page (D7). My question
> > is
> > how do I get the cell J16 on "OriginalInvoicepg1" to show the price from
> > the
> > "PartTable" page. Keeping in mind the Case Pricing columns for the 6
> > customers are a different amount.
> > I was given a formula of
> > =if(custtable!$c$1="",9999999,vlookup(f16,parttable!A:X,custtable!$c$1,false)).
> > I get a #ref! error message on this. Any suggestions?
> > Pete Elbert. I will be happy to email the spread sheet for a more clear
> > explanation.
>
>
>

I bet Biff wants you to figure out his email address from this line:

> xl can help at comcast period net

I'd change the at to @ and the period to . and get rid of all the spaces.

Many people munge their email id's so that those pesky "bots" can't glean id's
from the newsgroups and spam the heck out of the posters.



Pete Elbert wrote:
>
> How do I get in touch (email) you. I tried several times based on your email
> listed and I keep getting it sent back. Thanks again. My best email address
> is [email protected]
>
> "Biff" wrote:
>
> > Hi!
> >
> > I'll take look.
> >
> > xl can help at comcast period net
> >
> > Remove "can" and change the obvious.
> >
> > Biff
> >
> > "Pete Elbert" <[email protected]> wrote in message
> > news:[email protected]...
> > > D7 is a dropdown list of customer names. F16 is a drop down list of
> > > products.
> > > J16 is where I would like a price to be shown based on the price from
> > > another
> > > folder called PartTable. PartTable contains numerous columns. Product
> > > ID,
> > > Cntr Size, Cntr Desc, Cost are the first four columns. Next columns E
> > > thru V
> > > contain product pricing for 6 customers. Each customer has 3 columns
> > > (Colum1
> > > is ea price, Column 2 is Case Price, and Column 3 is GM%).
> > > In a folder called CustTable, in cell C1 the following formula is
> > > used=IF(OriginalInvoicepg1!D7="","",VLOOKUP(OriginalInvoicepg1!D7,CustTable!A:B,2,FALSE))
> > > to identify the customer on "OriginalInvloicepg1" page (D7). My question
> > > is
> > > how do I get the cell J16 on "OriginalInvoicepg1" to show the price from
> > > the
> > > "PartTable" page. Keeping in mind the Case Pricing columns for the 6
> > > customers are a different amount.
> > > I was given a formula of
> > > =if(custtable!$c$1="",9999999,vlookup(f16,parttable!A:X,custtable!$c$1,false)).
> > > I get a #ref! error message on this. Any suggestions?
> > > Pete Elbert. I will be happy to email the spread sheet for a more clear
> > > explanation.
> >
> >
> >

--

Dave Peterson

Hopefully I solved the mystery email address. Thanks for the help with this.

"Dave Peterson" wrote:

> I bet Biff wants you to figure out his email address from this line:
>
> > xl can help at comcast period net
>
> I'd change the at to @ and the period to . and get rid of all the spaces.
>
> Many people munge their email id's so that those pesky "bots" can't glean id's
> from the newsgroups and spam the heck out of the posters.
>
>
>
> Pete Elbert wrote:
> >
> > How do I get in touch (email) you. I tried several times based on your email
> > listed and I keep getting it sent back. Thanks again. My best email address
> > is [email protected]
> >
> > "Biff" wrote:
> >
> > > Hi!
> > >
> > > I'll take look.
> > >
> > > xl can help at comcast period net
> > >
> > > Remove "can" and change the obvious.
> > >
> > > Biff
> > >
> > > "Pete Elbert" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > D7 is a dropdown list of customer names. F16 is a drop down list of
> > > > products.
> > > > J16 is where I would like a price to be shown based on the price from
> > > > another
> > > > folder called PartTable. PartTable contains numerous columns. Product
> > > > ID,
> > > > Cntr Size, Cntr Desc, Cost are the first four columns. Next columns E
> > > > thru V
> > > > contain product pricing for 6 customers. Each customer has 3 columns
> > > > (Colum1
> > > > is ea price, Column 2 is Case Price, and Column 3 is GM%).
> > > > In a folder called CustTable, in cell C1 the following formula is
> > > > used=IF(OriginalInvoicepg1!D7="","",VLOOKUP(OriginalInvoicepg1!D7,CustTable!A:B,2,FALSE))
> > > > to identify the customer on "OriginalInvloicepg1" page (D7). My question
> > > > is
> > > > how do I get the cell J16 on "OriginalInvoicepg1" to show the price from
> > > > the
> > > > "PartTable" page. Keeping in mind the Case Pricing columns for the 6
> > > > customers are a different amount.
> > > > I was given a formula of
> > > > =if(custtable!$c$1="",9999999,vlookup(f16,parttable!A:X,custtable!$c$1,false)).
> > > > I get a #ref! error message on this. Any suggestions?
> > > > Pete Elbert. I will be happy to email the spread sheet for a more clear
> > > > explanation.
> > >
> > >
> > >
>
> --
>
> Dave Peterson
>

Yes, you've figured it out!

Unfortunately, I'm experiencing problems with you file. Excel is crashing
when I select one of your invoice sheets. It then reopens the recovered
(repaired) file but then all the formatting has been stripped out of the
entire file. This makes the invoice sheets a real mess!

Sorry, I guess I can't help you. Without the formatting the data is strewn
all over and is too hard to figure out.

Biff

"Pete Elbert" <[email protected]> wrote in message
news:[email protected]...
> Hopefully I solved the mystery email address. Thanks for the help with
> this.
>
> "Dave Peterson" wrote:
>
>> I bet Biff wants you to figure out his email address from this line:
>>
>> > xl can help at comcast period net
>>
>> I'd change the at to @ and the period to . and get rid of all the spaces.
>>
>> Many people munge their email id's so that those pesky "bots" can't glean
>> id's
>> from the newsgroups and spam the heck out of the posters.
>>
>>
>>
>> Pete Elbert wrote:
>> >
>> > How do I get in touch (email) you. I tried several times based on your
>> > email
>> > listed and I keep getting it sent back. Thanks again. My best email
>> > address
>> > is [email protected]
>> >
>> > "Biff" wrote:
>> >
>> > > Hi!
>> > >
>> > > I'll take look.
>> > >
>> > > xl can help at comcast period net
>> > >
>> > > Remove "can" and change the obvious.
>> > >
>> > > Biff
>> > >
>> > > "Pete Elbert" <[email protected]> wrote in message
>> > > news:[email protected]...
>> > > > D7 is a dropdown list of customer names. F16 is a drop down list of
>> > > > products.
>> > > > J16 is where I would like a price to be shown based on the price
>> > > > from
>> > > > another
>> > > > folder called PartTable. PartTable contains numerous columns.
>> > > > Product
>> > > > ID,
>> > > > Cntr Size, Cntr Desc, Cost are the first four columns. Next
>> > > > columns E
>> > > > thru V
>> > > > contain product pricing for 6 customers. Each customer has 3
>> > > > columns
>> > > > (Colum1
>> > > > is ea price, Column 2 is Case Price, and Column 3 is GM%).
>> > > > In a folder called CustTable, in cell C1 the following formula is
>> > > > used=IF(OriginalInvoicepg1!D7="","",VLOOKUP(OriginalInvoicepg1!D7,CustTable!A:B,2,FALSE))
>> > > > to identify the customer on "OriginalInvloicepg1" page (D7). My
>> > > > question
>> > > > is
>> > > > how do I get the cell J16 on "OriginalInvoicepg1" to show the price
>> > > > from
>> > > > the
>> > > > "PartTable" page. Keeping in mind the Case Pricing columns for the
>> > > > 6
>> > > > customers are a different amount.
>> > > > I was given a formula of
>> > > > =if(custtable!$c$1="",9999999,vlookup(f16,parttable!A:X,custtable!$c$1,false)).
>> > > > I get a #ref! error message on this. Any suggestions?
>> > > > Pete Elbert. I will be happy to email the spread sheet for a more
>> > > > clear
>> > > > explanation.
>> > >
>> > >
>> > >
>>
>> --
>>
>> Dave Peterson
>>

Let me reduce the file down to bare bones and try resending it. Pete

"Biff" wrote:

> Yes, you've figured it out!
>
> Unfortunately, I'm experiencing problems with you file. Excel is crashing
> when I select one of your invoice sheets. It then reopens the recovered
> (repaired) file but then all the formatting has been stripped out of the
> entire file. This makes the invoice sheets a real mess!
>
> Sorry, I guess I can't help you. Without the formatting the data is strewn
> all over and is too hard to figure out.
>
> Biff
>
> "Pete Elbert" <[email protected]> wrote in message
> news:[email protected]...
> > Hopefully I solved the mystery email address. Thanks for the help with
> > this.
> >
> > "Dave Peterson" wrote:
> >
> >> I bet Biff wants you to figure out his email address from this line:
> >>
> >> > xl can help at comcast period net
> >>
> >> I'd change the at to @ and the period to . and get rid of all the spaces.
> >>
> >> Many people munge their email id's so that those pesky "bots" can't glean
> >> id's
> >> from the newsgroups and spam the heck out of the posters.
> >>
> >>
> >>
> >> Pete Elbert wrote:
> >> >
> >> > How do I get in touch (email) you. I tried several times based on your
> >> > email
> >> > listed and I keep getting it sent back. Thanks again. My best email
> >> > address
> >> > is [email protected]
> >> >
> >> > "Biff" wrote:
> >> >
> >> > > Hi!
> >> > >
> >> > > I'll take look.
> >> > >
> >> > > xl can help at comcast period net
> >> > >
> >> > > Remove "can" and change the obvious.
> >> > >
> >> > > Biff
> >> > >
> >> > > "Pete Elbert" <[email protected]> wrote in message
> >> > > news:[email protected]...
> >> > > > D7 is a dropdown list of customer names. F16 is a drop down list of
> >> > > > products.
> >> > > > J16 is where I would like a price to be shown based on the price
> >> > > > from
> >> > > > another
> >> > > > folder called PartTable. PartTable contains numerous columns.
> >> > > > Product
> >> > > > ID,
> >> > > > Cntr Size, Cntr Desc, Cost are the first four columns. Next
> >> > > > columns E
> >> > > > thru V
> >> > > > contain product pricing for 6 customers. Each customer has 3
> >> > > > columns
> >> > > > (Colum1
> >> > > > is ea price, Column 2 is Case Price, and Column 3 is GM%).
> >> > > > In a folder called CustTable, in cell C1 the following formula is
> >> > > > used=IF(OriginalInvoicepg1!D7="","",VLOOKUP(OriginalInvoicepg1!D7,CustTable!A:B,2,FALSE))
> >> > > > to identify the customer on "OriginalInvloicepg1" page (D7). My
> >> > > > question
> >> > > > is
> >> > > > how do I get the cell J16 on "OriginalInvoicepg1" to show the price
> >> > > > from
> >> > > > the
> >> > > > "PartTable" page. Keeping in mind the Case Pricing columns for the
> >> > > > 6
> >> > > > customers are a different amount.
> >> > > > I was given a formula of
> >> > > > =if(custtable!$c$1="",9999999,vlookup(f16,parttable!A:X,custtable!$c$1,false)).
> >> > > > I get a #ref! error message on this. Any suggestions?
> >> > > > Pete Elbert. I will be happy to email the spread sheet for a more
> >> > > > clear
> >> > > > explanation.
> >> > >
> >> > >
> >> > >
> >>
> >> --
> >>
> >> Dave Peterson
> >>
>
>
>

OK, try it.

Your file isn't that big so I don't think it's a memory problem.

Biff

"Pete Elbert" <[email protected]> wrote in message
news:[email protected]...
> Let me reduce the file down to bare bones and try resending it. Pete
>
> "Biff" wrote:
>
>> Yes, you've figured it out!
>>
>> Unfortunately, I'm experiencing problems with you file. Excel is crashing
>> when I select one of your invoice sheets. It then reopens the recovered
>> (repaired) file but then all the formatting has been stripped out of the
>> entire file. This makes the invoice sheets a real mess!
>>
>> Sorry, I guess I can't help you. Without the formatting the data is
>> strewn
>> all over and is too hard to figure out.
>>
>> Biff
>>
>> "Pete Elbert" <[email protected]> wrote in message
>> news:[email protected]...
>> > Hopefully I solved the mystery email address. Thanks for the help with
>> > this.
>> >
>> > "Dave Peterson" wrote:
>> >
>> >> I bet Biff wants you to figure out his email address from this line:
>> >>
>> >> > xl can help at comcast period net
>> >>
>> >> I'd change the at to @ and the period to . and get rid of all the
>> >> spaces.
>> >>
>> >> Many people munge their email id's so that those pesky "bots" can't
>> >> glean
>> >> id's
>> >> from the newsgroups and spam the heck out of the posters.
>> >>
>> >>
>> >>
>> >> Pete Elbert wrote:
>> >> >
>> >> > How do I get in touch (email) you. I tried several times based on
>> >> > your
>> >> > email
>> >> > listed and I keep getting it sent back. Thanks again. My best
>> >> > email
>> >> > address
>> >> > is [email protected]
>> >> >
>> >> > "Biff" wrote:
>> >> >
>> >> > > Hi!
>> >> > >
>> >> > > I'll take look.
>> >> > >
>> >> > > xl can help at comcast period net
>> >> > >
>> >> > > Remove "can" and change the obvious.
>> >> > >
>> >> > > Biff
>> >> > >
>> >> > > "Pete Elbert" <[email protected]> wrote in
>> >> > > message
>> >> > > news:[email protected]...
>> >> > > > D7 is a dropdown list of customer names. F16 is a drop down list
>> >> > > > of
>> >> > > > products.
>> >> > > > J16 is where I would like a price to be shown based on the price
>> >> > > > from
>> >> > > > another
>> >> > > > folder called PartTable. PartTable contains numerous columns.
>> >> > > > Product
>> >> > > > ID,
>> >> > > > Cntr Size, Cntr Desc, Cost are the first four columns. Next
>> >> > > > columns E
>> >> > > > thru V
>> >> > > > contain product pricing for 6 customers. Each customer has 3
>> >> > > > columns
>> >> > > > (Colum1
>> >> > > > is ea price, Column 2 is Case Price, and Column 3 is GM%).
>> >> > > > In a folder called CustTable, in cell C1 the following formula
>> >> > > > is
>> >> > > > used=IF(OriginalInvoicepg1!D7="","",VLOOKUP(OriginalInvoicepg1!D7,CustTable!A:B,2,FALSE))
>> >> > > > to identify the customer on "OriginalInvloicepg1" page (D7). My
>> >> > > > question
>> >> > > > is
>> >> > > > how do I get the cell J16 on "OriginalInvoicepg1" to show the
>> >> > > > price
>> >> > > > from
>> >> > > > the
>> >> > > > "PartTable" page. Keeping in mind the Case Pricing columns for
>> >> > > > the
>> >> > > > 6
>> >> > > > customers are a different amount.
>> >> > > > I was given a formula of
>> >> > > > =if(custtable!$c$1="",9999999,vlookup(f16,parttable!A:X,custtable!$c$1,false)).
>> >> > > > I get a #ref! error message on this. Any suggestions?
>> >> > > > Pete Elbert. I will be happy to email the spread sheet for a
>> >> > > > more
>> >> > > > clear
>> >> > > > explanation.
>> >> > >
>> >> > >
>> >> > >
>> >>
>> >> --
>> >>
>> >> Dave Peterson
>> >>
>>
>>
>>