+ Reply to Thread
Results 1 to 20 of 20

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

Hybrid View

shtuamouth Comparing two columns, and... 03-12-2014, 07:47 PM
Richard Buttrey Re: Comparing two columns,... 03-12-2014, 08:09 PM
shtuamouth Re: Comparing two columns,... 03-13-2014, 01:53 AM
shtuamouth Re: Comparing two columns,... 03-13-2014, 02:02 AM
Richard Buttrey Re: Comparing two columns,... 03-13-2014, 05:50 AM
shtuamouth Re: Comparing two columns,... 03-13-2014, 04:20 PM
shtuamouth Re: Comparing two columns,... 03-13-2014, 02:11 PM
Richard Buttrey Re: Comparing two columns,... 03-13-2014, 02:33 PM
newdoverman Re: Comparing two columns,... 03-13-2014, 03:31 PM
newdoverman Re: Comparing two columns,... 03-13-2014, 05:12 PM
shtuamouth Re: Comparing two columns,... 03-13-2014, 05:35 PM
newdoverman Re: Comparing two columns,... 03-13-2014, 05:52 PM
shtuamouth Re: Comparing two columns,... 03-13-2014, 07:45 PM
newdoverman Re: Comparing two columns,... 03-13-2014, 07:59 PM
shtuamouth Re: Comparing two columns,... 03-14-2014, 05:16 PM
newdoverman Re: Comparing two columns,... 03-14-2014, 07:36 PM
shtuamouth Re: Comparing two columns,... 03-15-2014, 03:02 PM
newdoverman Re: Comparing two columns,... 03-15-2014, 04:16 PM
shtuamouth Re: Comparing two columns,... 03-15-2014, 04:31 PM
newdoverman Re: Comparing two columns,... 03-15-2014, 04:50 PM
  1. #1
    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
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  2. #2
    Registered User
    Join Date
    03-08-2014
    Location
    islamabad, pakistan
    MS-Off Ver
    Excel 2007
    Posts
    35

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

    thank you so much newdoverman. it worked.

    God bless you

+ Reply to Thread

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