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>
Category
Item
WK1
WK2
Aprons(Blue Sownedge)
Aprons
$718.15
$977.76
Boots(Lite)
Boots
$115.81...