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

"Biff" wrote:

Hi!

I'll take look.

xl can help at comcast period net

Remove "can" and change the obvious.

Biff

"Pete Elbert" wrote in message
...
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(Origin alInvoicepg1!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,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.




--

Dave Peterson