Can I use VLOKUP to match a list of items to populate a combo box? Say
"Speakers in-ceiling". If so than I can use "Match" if the item is chosen
to populate the cost, price and time to install cells.

Marc

"Dave Peterson" wrote in message
...
I think I would use/add a key column that I can use to match up with the
price
book.

For instance, if the user chooses a nice unique item/description/part
number in
the Quote workbook, you could use formulas to retrieve the data that you
want.

In general, it'll look something like:


=IF(A1="","",IF(ISERROR(VLOOKUP(A1,[book2.xls]Sheet1!$A:$F,2,FALSE)),"Missin
g",
VLOOKUP(A1,[book2.xls]Sheet1!$A:$F,2,FALSE)))

(that's with the "sending" workbook open.)

If you close that other workbook, excel will adjust the formula to include
the
paths:

=IF(A1="","",IF(ISERROR(
VLOOKUP(A1,'C:\My Documents\excel\[book2.xls]Sheet1'!$A:$F,2,FALSE)),
"Missing",
VLOOKUP(A1,'C:\My Documents\excel\[book2.xls]Sheet1'!$A:$F,2,FALSE)))

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())


Marc wrote:

In some cases the prices are linked from the price book to the quote
book.
If I make changes added lines to the price book and the quote book is
not
opened the the quote books will not update correctly. Correct? If both
books are open I can get around this. Correct? I tried getting some
help
with a macro that would do this but I haven't had any but I think that
this
would solve the problem. I would like to use a combo box that is
populated
by all the matches in column B and than have other cell in the same row
bet
filled with the price, cost and time to install. Any suggestions?

I know hire a professional!!!!

Marc:)

--

Dave Peterson