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.
[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD] Category
[/TD]
[TD]Item
[/TD]
[TD]WK1
[/TD]
[TD]WK2
[/TD]
[/TR]
[TR]
[TD]Aprons(Blue Sownedge)
[/TD]
[TD]Aprons
[/TD]
[TD]$718.15
[/TD]
[TD]$977.76
[/TD]
[/TR]
[TR]
[TD]Boots(Lite)
[/TD]
[TD]Boots
[/TD]
[TD]$115.81
[/TD]
[TD]$0
[/TD]
[/TR]
[TR]
[TD]Bump Caps
[/TD]
[TD]Bump Caps
[/TD]
[TD]$116.90
[/TD]
[TD]$0
[/TD]
[/TR]
[TR]
[TD]Calculator
[/TD]
[TD]Cal
[/TD]
[TD]$44.48
[/TD]
[TD]$0
[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]Cost Center
[/TD]
[TD]Category<strike></strike>
[/TD]
[TD]Item
[/TD]
[TD]WK1
[/TD]
[TD]W2
[/TD]
[TD]W3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]112210
[/TD]
[TD]Aprons(Blue Sownedge)
[/TD]
[TD]Aprons
[/TD]
[TD]$26.97
[/TD]
[TD]$33.72
[/TD]
[TD]$33.72
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Bump Caps
[/TD]
[TD]Caps
[/TD]
[TD]$2.25
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Glove NonMetal
[/TD]
[TD]Blue Latex
[/TD]
[TD]$13.16
[/TD]
[TD]$16.40
[/TD]
[TD]$16.40
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]112290
[/TD]
[TD]Aprons(Blue Sownedge)
[/TD]
[TD]Aprons
[/TD]
[TD]$85.98
[/TD]
[TD]$143.49
[/TD]
[TD]$114.63
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Bump Caps
[/TD]
[TD]Caps
[/TD]
[TD]$13.49
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD] Category
[/TD]
[TD]Item
[/TD]
[TD]WK1
[/TD]
[TD]WK2
[/TD]
[/TR]
[TR]
[TD]Aprons(Blue Sownedge)
[/TD]
[TD]Aprons
[/TD]
[TD]$718.15
[/TD]
[TD]$977.76
[/TD]
[/TR]
[TR]
[TD]Boots(Lite)
[/TD]
[TD]Boots
[/TD]
[TD]$115.81
[/TD]
[TD]$0
[/TD]
[/TR]
[TR]
[TD]Bump Caps
[/TD]
[TD]Bump Caps
[/TD]
[TD]$116.90
[/TD]
[TD]$0
[/TD]
[/TR]
[TR]
[TD]Calculator
[/TD]
[TD]Cal
[/TD]
[TD]$44.48
[/TD]
[TD]$0
[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]Cost Center
[/TD]
[TD]Category<strike></strike>
[/TD]
[TD]Item
[/TD]
[TD]WK1
[/TD]
[TD]W2
[/TD]
[TD]W3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]112210
[/TD]
[TD]Aprons(Blue Sownedge)
[/TD]
[TD]Aprons
[/TD]
[TD]$26.97
[/TD]
[TD]$33.72
[/TD]
[TD]$33.72
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Bump Caps
[/TD]
[TD]Caps
[/TD]
[TD]$2.25
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Glove NonMetal
[/TD]
[TD]Blue Latex
[/TD]
[TD]$13.16
[/TD]
[TD]$16.40
[/TD]
[TD]$16.40
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]112290
[/TD]
[TD]Aprons(Blue Sownedge)
[/TD]
[TD]Aprons
[/TD]
[TD]$85.98
[/TD]
[TD]$143.49
[/TD]
[TD]$114.63
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Bump Caps
[/TD]
[TD]Caps
[/TD]
[TD]$13.49
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]