Results 1 to 5 of 5

Thread: Search by word and replace with Date from another sheet!

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 03-14-2015, 06:13 PM #5
    Ingolf
    Ingolf is offline
    Member
    Join Date
    Jul 2012
    Posts
    55
    Rep Power
    13
    Why not normal formula?

    E4 =SUMPRODUCT((Int!$A$2:$A$13=Int!$A$2)*(Int!$B$2:$B $13=$C4)*(Int!$C$2:$C$13))
    F4 =SUMPRODUCT((Int!$A$2:$A$13=Int!$A$2)*(Int!$B$2:$B $13=$C4)*(Int!$D$2:$D$13))
    Last edited by Ingolf; 03-14-2015 at 06:15 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. VBA Code To Loop Cells In A Column One By One And Search In Another Sheet
    By naseerrahaman in forum Excel Help
    Replies: 1
    Last Post: 06-12-2013, 07:42 PM
  2. Replace Incorrect Date In Cell To Another Valid Date
    By DARSHANKmandya in forum Excel and VBA Tips and Tricks
    Replies: 2
    Last Post: 03-21-2013, 09:27 PM
  3. Search form on work sheet
    By Ryan_Bernal in forum Excel Help
    Replies: 5
    Last Post: 01-15-2013, 11:46 AM
  4. Search word in different workbooks and sheets
    By k0st4din in forum Excel Help
    Replies: 5
    Last Post: 11-29-2012, 10:10 PM
  5. Word 2013 doesn't show unicode text in find/replace window, shows black boxes.
    By vsrawat in forum Word Help
    Replies: 2
    Last Post: 09-25-2012, 01:30 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules