VLook Up Help

icigarro

New Member
Joined
Mar 14, 2018
Messages
1
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.



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>
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Watch MrExcel Video

Forum statistics

Threads
1,109,533
Messages
5,529,397
Members
409,870
Latest member
Well59
Top