software

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=quot;quot;,quot;quot;,VLOOKUP(Origin alInvoicepg1!D7,CustTable!A:B,2,FALSE))
to identify the customer on quot;OriginalInvloicepg1quot; page (D7). My question is
how do I get the cell J16 on quot;OriginalInvoicepg1quot; to show the price from the
quot;PartTablequot; 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=quot;quot;,9999999,vlookup(f16,parttabl e!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 quot;canquot; and change the obvious.

Biff

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

quot;Biffquot; wrote:

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

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

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

--

Dave Peterson

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

quot;Dave Petersonquot; wrote:

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

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

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

quot;Biffquot; wrote:

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

OK, try it.

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

Biff

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