VLookup from SQL Database

[Databasehelp]

Hi All,

What I'm trying to do is take from a SQL Database that we have in our system to populate an external material sheet. That being said, here is a sample of what I'm dealing with.

Item_ID	Qty	Work Order	Item Description
	0	PW10388
30-315	1	PW10388	Item 2
30-608	1	PW10388	Item 3
30-610	1	PW10388	Item 4
30-612	2	PW10388	Item 5
30-611	4	PW10388	Item 6
30-613	4	PW10388	Item 7
P30-505	18	PW10388	Item 8
30-302	2	PW10388	Item 9
30-403	4	PW10388	Item 10
30-616	2	PW10388	Item 11
60-102	3	PW10389	Item 12
P30-315	3	PW10389	Item 13
30-609	3	PW10389	Item 14
30-613B	3	PW10389	Item 15
30-511B	1	PW10389	Item 16
30-608	1	PW10389	Item 17
30-610	1	PW10389	Item 18
30-315	1	PW10389	Item 19
30-608	1	PW10389	Item 20
30-610	1	PW10389	Item 21

<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>

What I want to do is type in the work order "PW10388" and for the material sheet to populate any work order with that number to populate the rest of the information (Item ID, Qty and description in different columns). What I'm trying to do is use a VLookup which would look to the right and find that item. I'm not sure if that is being stopped since the first item qty is always 0 in the database (along with a description that has no description, essentially 0). It will keep reading the same output as 0 or N/A.

When I use a index/match it has a problem reading the same work order twice and tends to look at the smallest number, when in fact I need every item to be populated. I use the entire column as the formula opposed to extending as set of value (e2:e999999) As this will be used for a while and our database is already getting up to that number quickly.

=INDEX(Item Description,MATCH(A3, WorkOrder,0))

Item Description as seen above in table A3 is the work order number that I type on the material list. In my mind it should grab from the work order that I typed in. Look for any match of that work order and spit out the description (and hopefully the Quantity, labelled Qty). Again, what i'm running into is that there are multiple of the same number and it keeps taking the top number. We also have a separate database that I believe I can setup with item description and item id's so that when I populate the description, the Item Id will automatically populate as well. If anybody can possibly steer me in the right direction, that would be greatly appreciated.

<tbody style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image: none; background-origin: padding-box; background-position-x: 0%; background-position-y: 0%; background-repeat: repeat; background-size: auto; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-size-adjust: none; font-stretch: 100%; font-style: normal; font-variant: normal; font-weight: 400; line-height: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;">
</tbody>

<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>

 

[jmacleary]

Hi there. You say that the database is growing rapidly. Why not modify your sql query to take your input work order number and only return data that matches. You could also add a criterion to the query to only return non-zero quantities.