Hey Guys!
I was hoping to find out a way to build a list based off a pivot table I created. Basically, I am trying to find out a way to perform a lookup based on certain conditions and have it spit out the corresponding results into a different spreadsheet.
If(Subtotal > 200)
then(return Customer)
In other words, I would like to turn this:
Customer Subtotal
ABC 2834.25
DEF 113
GHI 202
JKL 49.64
MNO 146.1
PQR 22.5
STU 1098.95
VWX 48
Into this:
ABC
GHI
STU
Bookmarks