simultaneous entry lookup problems
 

Hi,

I have a spreadsheet filled with thousands of different inventory
items. Each column represents a characteristic, size, type, product
code. Each row is a different item.

One of our columns is the product code of the same item, only in our
major competitors product line. Our clients often give us spreadsheets
with nothing but a giant column with this competitors product codes.

I need to be able to plug this column of individual item codes into
excell and have it pick out the appropriate items associated with the
code and spit it back out all together.

I can find many ways to put only one product code and getting one
inventory item in return, my problem is that I am unable to find a way
to retrieve many inventory items at a time.

Thanks


--
arieck
------------------------------------------------------------------------
arieck's Profile: http://www.excelforum.com/member.php...o&userid=26321
View this thread: http://www.excelforum.com/showthread...hreadid=395923

You should use a database for this type a data proccessing.

it would be one SQL statment to get a recordset with the desired
records.

but if you have to stick to Excel take these steps:

1) sort your product sheet on the competetors article code
2) sort the clients column the same way.
3)take the first item in the client list aand search for it in your
list
4)if found copy the row/record to another sheet
5)read the next item from the clients list and continue the search on
the row you have copied.
6) stop at the last row of your productsheet (PROBLEM)
7)or if you have found the last item (SUCCES)

this way you have to walk through your product sheet once......There's
one BIG drawback if the customer has entered a code not in your
productsheet you have to do something like skip it and search the next
item in the column or generate an error


--
Dnereb
------------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=395923

Well I don't have to stick with excel, I have Access. Haven't used it
much though. How would one go about the creating the appropriate SQL
statement?

Thanks


--
arieck
------------------------------------------------------------------------
arieck's Profile: http://www.excelforum.com/member.php...o&userid=26321
View this thread: http://www.excelforum.com/showthread...hreadid=395923