What I am doing: I have two separate worksheets with multiple columns each (basic stuff); Pending and Disbursements. I want to set up a formula that will take a name from my Pending worksheet and input it in my Disbursement worksheet if it meets the criteria. That part I can do, no problem. Where I am having issues is when I fill the formula down, I start getting blank cells between names; and that I do not want.
So what I am really trying to do is set up a formula that will fill the next matching criteria name in the next cell. Here is the last attempt of mine to do so: =IF([Pending.xls]May!$H10="Y", [Pending.xls]May!$C10, IF([Pending.xls]May!$H11="Y", [Pending.xls]May!$C11, IF([Pending.xls]May!$H12="Y", [Pending.xls]May!$C12, "")))
The issue there is that I get two cells that fill the same name, and every third cell changes name (i.e. Smith, Smith, Jones, Brown, Brown, Denis, etc., etc.)
Any suggestions (see bold/italics/underlined)? Thank y'all in advance!
Bookmarks