Badge #</SPAN> | Division</SPAN> | Location Name</SPAN> | Employee</SPAN> | Product</SPAN> | Count</SPAN> | Date</SPAN> | |
14844</SPAN> | 403</SPAN> | Denver 5</SPAN> | Paul</SPAN> | Apples</SPAN> | 33</SPAN> | 1/2/2012</SPAN> | |
14844</SPAN> | 403</SPAN> | Denver 5</SPAN> | Paul </SPAN> | Bananas</SPAN> | 55</SPAN> | 1/1/2012</SPAN> | |
14844</SPAN> | 403</SPAN> | Denver 7</SPAN> | Paul</SPAN> | Oranges</SPAN> | 46</SPAN> | 1/2/2012</SPAN> | |
14846</SPAN> | 106</SPAN> | Seattle 4 </SPAN> | Phil</SPAN> | Apples</SPAN> | 34</SPAN> | 1/3/2012</SPAN> | |
14846</SPAN> | 106</SPAN> | Seattle 4 </SPAN> | Phil</SPAN> | Bananas</SPAN> | 34</SPAN> | 1/3/2012</SPAN> | |
14846</SPAN> | 106</SPAN> | Seattle 5</SPAN> | Phil</SPAN> | Bananas</SPAN> | 45</SPAN> | 1/5/2012</SPAN> | |
14850</SPAN> | 115</SPAN> | Oakland 12</SPAN> | Stan</SPAN> | Oranges</SPAN> | 42</SPAN> | 1/5/2012</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>
This is the current formula I am using: =VLOOKUP($D25,'AUG INV'!$D$2:$U$2500,COLUMN($A1:B1),FALSE)
This Formula is sorting through the data sheet, selecting by Location Name & then populating the corresponding data via the "Column" formula, however if say there is another data set with the SAME Location Name but a different Product, the Formula doesn't distinguish and just pulls the SAME data set again & again.
I am looking for a Formula that will search the Inventory data, pulling by Location Name and pulling ALL instances with variable product (if applicable); will the INDEX formula work with this?
Appreciate all the expertise and assistance.
Thanks!