I got a pivot table and I want to be able to vlook up multiple Rows. Right now I have it like this so simple VLOOKUP. Ex. =VLOOKUP(A2,A:D,3,false) which would give me $718.15.
<tbody>
</tbody>
But I want to do a more deeper search. Need help for ex what ever is in Cost Center 112210 just for Aprons in WK1 for $26.97 and then what ever is in cost center 112290 for Aprons WK 2 for $143.49. this is all in a pivot table and need help doing the formula.
<tbody>
</tbody>
| Category | Item | WK1 | WK2 |
| Aprons(Blue Sownedge) | Aprons | $718.15 | $977.76 |
| Boots(Lite) | Boots | $115.81 | $0 |
| Bump Caps | Bump Caps | $116.90 | $0 |
| Calculator | Cal | $44.48 | $0 |
<tbody>
</tbody>
But I want to do a more deeper search. Need help for ex what ever is in Cost Center 112210 just for Aprons in WK1 for $26.97 and then what ever is in cost center 112290 for Aprons WK 2 for $143.49. this is all in a pivot table and need help doing the formula.
| Cost Center | Category<strike></strike> | Item | WK1 | W2 | W3 | |||||||
| 112210 | Aprons(Blue Sownedge) | Aprons | $26.97 | $33.72 | $33.72 | |||||||
| Bump Caps | Caps | $2.25 | ||||||||||
| Glove NonMetal | Blue Latex | $13.16 | $16.40 | $16.40 | ||||||||
| 112290 | Aprons(Blue Sownedge) | Aprons | $85.98 | $143.49 | $114.63 | |||||||
| Bump Caps | Caps | $13.49 |
<tbody>
</tbody>
