I'd like to add one more criteria in the formula below. The pivot where the formula gets its data from has a third column, and i want it to only show results with a "N" in column D. (Sheet 'Data Units') Right now it shows just the first results it can find in the validation listbox that I applied in B4. How do I add it to the formula below? Iv shown it very easily in the attached document. I tried Index Match but no avail.
=OFFSET(Pivot!$B$1, MATCH($A2, Pivot!$A:$A, 0)-1, , $B2, )
f.xlsm
maybe you can add another criteria using if inside the match something like
=OFFSET(Pivot!$B$1, MATCH($A5, IF(Pivot!$C$2:$C$17="N",Pivot!$A:$A, 0))-1, , $B5, )
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Wow that worked, thanks!! +Rep for u
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks