+ Reply to Thread
Results 1 to 4 of 4

two columns and then a third value

  1. #1
    Registered User
    Join Date
    05-05-2013
    Location
    Richmond, Va
    MS-Off Ver
    Excel 2003
    Posts
    2

    two columns and then a third value

    Hello
    I have two columns that have random item #'s. Some of these numbers match. If they do, I would like to assign that item number the price from column three.
    Column A has 2000 item numbers, Column B has 1100 item numbers (some that match Column A), and Column C has prices related to Column B. I want to take the 1100 item numbers' prices from Column C and attach them to the item numbers in Column A. Does this make sense?
    Thans

  2. #2
    Forum Contributor
    Join Date
    12-23-2003
    Posts
    179

    Re: two columns and then a third value

    What do you mean by attach if it's not

    =VLOOKUP(A2,B:C,2,0)

    would deliver?

  3. #3
    Registered User
    Join Date
    05-05-2013
    Location
    Richmond, Va
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: two columns and then a third value

    Thank you. That worked nicely.

  4. #4
    Forum Contributor
    Join Date
    12-23-2003
    Posts
    179

    Re: two columns and then a third value

    You are welcome.

+ Reply to Thread

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