Results 1 to 7 of 7

Trying to search a column and match values

Threaded View

  1. #1
    Registered User
    Join Date
    03-25-2018
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    3

    Trying to search a column and match values

    Hi,

    First of all, I've tried a lot of fixes to get the two different date formats (column A saved as text and I can't get it to be a date) so I can match values from 2 columns. Basically what I want to do is match a date in column A with a date in column D, then use the value in E that corresponds to the date in D to multiply column B by E. I was trying to use the MATCH function and IF but I'm just completely lost now. I hope this description of what I'm trying to do makes sense. Or maybe there's just and easier way to do it that I don't see.

    Thanks for the help!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 09-03-2015, 09:51 PM
  2. [SOLVED] Return Multiple values from a column with index and match, and search criteria
    By marcusduton in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 02-15-2015, 09:59 PM
  3. Replies: 3
    Last Post: 03-21-2014, 03:29 AM
  4. Replies: 4
    Last Post: 10-28-2013, 10:57 AM
  5. Replies: 7
    Last Post: 08-04-2013, 03:41 PM
  6. [SOLVED] Match search terms, and add data in next column. Multi search problem.
    By Wales MB in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-23-2013, 06:10 PM
  7. Search and Find Match Values and Paste Match Values to a Row
    By jeffheartnet in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-26-2012, 08:34 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1