Item Master/Price list - DB functionality

[eljohnsoniii]

Hello everyone,

I'm a newbie here, and I am hoping that I describe this well. I have an item master/pricelist and item master file in excel that is made up of multiple worksheets. Each worksheet represents a different item. In each worksheet, I have fields called ITEM, ITEM DESCRIPTION, and UNIT PRICE. Since we use tiered pricing (we are a software company), the records look something like this:

ITEM NO ITEM DESC PRICE
101010 KAS AV MUL <9 $49.00
101011 KAS AV MUL <25 $42.00
101012 KAS AV MUL <50 $39.00

I also have a worksheet that I have formatted as a "software quote form." It has fields for Item number, Item desc, qty, unit price, extended price.

What I would like to do (you've probably guessed by now) is, on this quote worksheet, enter the ITEM NUMBER in the ITEM field, and have a macro retrieve the appropriate item record and populate the ITEM Description and Unit Price fields.

How would you suggest I resolve this?

Thanks so much for your help!

Regards,

Ed J.

[tlafferty]

without having your workbook layout, I'd suggest using vlookup:

Please Login or Register  to view this content.

This will examine cell A1 and find its match in the first column of the named range database and pull over the matching value from column 3 which is the description. Change the 3 to a 4 to pull in the unit price. Select your database and give it the name database.

Regards,
Tom