+ Reply to Thread
Results 1 to 5 of 5

Match two celles and fill the third cell with data from the fourth

  1. #1
    Registered User
    Join Date
    09-07-2012
    Location
    Norway
    MS-Off Ver
    Excel 2007
    Posts
    3

    Match two celles and fill the third cell with data from the fourth

    Ok, so I'll give it a go.

    In sheet 1 i have two columns:
    AA filled with a number
    BB that I want a formula to fill

    In sheet 2 I have two colums:
    CC filled with the same type of numbers as in AA
    DD filled with info regarding the celles to the left (CC).

    Now I would like BB to be filled with info from DD if AA matches CC. Is this possible?

    Please se attached sample.

    Help.xlsx

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Match two celles and fill the third cell with data from the fourth

    tRY:

    =VLOOKUP(A2,Ark2!$A$2:$B$7,2,FALSE)

    you can use IFERROR to conceal errors...

    =IFERROR(VLOOKUP(A2,Ark2!$A$2:$B$7,2,FALSE),"")
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    09-07-2012
    Location
    Norway
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Match two celles and fill the third cell with data from the fourth

    I get an error here, did you get it to work in the sample?

  4. #4
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Match two celles and fill the third cell with data from the fourth

    If you use NBVC second formula you should not get a Error.
    In the Data in your column CC there is no 14,15,21 & 39.

    =IFERROR(VLOOKUP(A2,'Ark2'!$A$2:$B$7,2,0),"Not Available")

  5. #5
    Registered User
    Join Date
    09-07-2012
    Location
    Norway
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Match two celles and fill the third cell with data from the fourth

    Thanks alot, got it working now

+ 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