Hi, I have a GroupsTable located on the Tiers page with the following data...
Columns = GroupID,Tier1,Tier2,Tier3
Rows
Row1 = 0, Erin Miller, "", ""
Row2 = 1, Edward Lee, "", ""
Row3 = 2, Tamara Simmons
Row4 = 3, Ted Callaghan, Erin Miller, ""
Row5 = 4, Bill Turner, Ted Callaghan, Erin Miller
I want to display the value of INDEX(Groups,5,4) in a cell on the Sales-Commission page only after checking that row 4 column 2 value matches, and that the row 4 column 3 value matches, otherwise return "". I would appreciate any assistance as to the best way to accomplish this. I am stumped on this one.
Bookmarks