OK,
I'm bumping this thread to ask for a little more help with the same sheet.
If I want this to pull a row if it hits a match in either of 2 columns, how would you do that?
I'm using
=IF(F9=SALESMAN!D$1,DEALS!V8+1,V8)
in a hidden column on the worksheet where the data is entered on DEALS. F9 is where the salesman's name goes, so on SALESMAN where I can enter that guy's name in D1 I have this:
=IFERROR(INDEX(DEALS!$B$9:$B$408,MATCH(ROW(A1),DEALS!$V$9:$V$408,0)),"")
works great. but some deals are split, so I have another column, (G) where the 2nd guy goes, and another hidden column with
=IF(G9=SALESMAN!$D$1,DEALS!W8+1,W8)
in it.
can I incorporate an OR somehow, so that it will list the deals if it matches the name in d1 in EITHER column F OR G ??
Bookmarks