Results 1 to 4 of 4

Need to compare values of two columns and return the adjacent value to a 3rd

Threaded View

  1. #1
    Registered User
    Join Date
    06-15-2010
    Location
    Dominican Republic
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question Need to compare values of two columns and return the adjacent value to a 3rd

    Hello,

    I have a large list of model/prices which I need to filter to update a new price list. see below.

    I have 4 columns, A B C D

    A = First List of Model Numbers
    B = New Prices of Models on A
    C = Second list of Model numbers
    D = Empty Price List

    What I want is to be able to Compare C to A and if the C is found on A, to copy B (Adjacent to the model found on A) to D.

    Any help is appreciated.

    Thanks in advance.
    Last edited by redstarx; 02-15-2012 at 01:19 AM.

Thread Information

Users Browsing this Thread

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

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