Question using excel with business price files

**KeithH** · 10-13-2009, 06:38 PM

Greetings

I have been saddled with a task that im not sure how to complete. The company I work for (a small retail store) uses Excel based pricing files. they have been manually changing pricing updates from vendors.

My question is: Can excell be made to do this ....

Parse the new price list file: Column A is always the Model number
Transfer the updated prices to the correct price line in the exsisting inventory file.

Example:
Inventory file shows
Column A: ....... Column B
#123 .............. $2.10
#456 .............. $3.14
#789 .............. $210.50

Its not always this cut and dry ... but thats the gist.I was hoping there would be a program that could automaticly scan the newer price file and be menu driven that could then deposit the information into the correct colums. Am i too hopefull ?

Thank you for the time you take responding to this, it is greatly appriciated.

Keith

**shg** · 10-13-2009, 06:42 PM

Welcome to the forum, Keith.

We're happy to help, but first please take a few minutes to read our forum rules, and then amend your thread title accordingly.

Thanks.

**shg** · 10-14-2009, 12:02 AM

Thanks.

Are you familiar with VLOOKUP? You can use a formula that gets the cuirrent pricing from the master pricelist.

If you need help, please post a workbook without any sensitive information.