Hi all,
I have a pivot table with all available items plus their corresponding attribute values. Unfortunately, some of the items have several seasonal delivery values, hence when using INDEX/MATCH in my Range sheet it will only return the first value and ignore the second (if any). Is there away to overcome such a problem? if possible without heavy array formulas??
Try
G3Formula:
=IFERROR(IF(OR(INDEX(Pivot!$A:$ZZ,$A3+COUNTIFS($A$3:A3,A3)-1,G$1)={0," ","(blank)"}),"UNKNOWN",INDEX(Pivot!$A:$ZZ,$A3+COUNTIFS($A$3:A3,A3)-1,G$1)),"#MISSING")
Copy down
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
That seems to work smoothly! Thanks!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks