Results 1 to 20 of 20

Comparing two columns, and returning values in the 4th column from the 3rd column

Threaded View

  1. #12
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Comparing two columns, and returning values in the 4th column from the 3rd column

    I fixed a couple of things. In the formula, the MATCH was referring to the wrong column and the values should have been numbers instead of text if you ever wanted to do calculations without problems. The formula was also in a column formatted as TEXT instead of GENERAL.
    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: 2
    Last Post: 11-14-2013, 01:44 PM
  2. Comparing 2 columns and returning a value of a 3rd column
    By usmc0331 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-17-2013, 10:55 AM
  3. Replies: 8
    Last Post: 12-25-2011, 08:39 PM
  4. comparing values and returning different column
    By JustMe602 in forum Excel General
    Replies: 12
    Last Post: 06-01-2007, 11:40 AM
  5. [SOLVED] Comparing values and returning the column heading
    By Steven Brobst in forum Excel General
    Replies: 3
    Last Post: 02-04-2005, 10:06 PM

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