Results 1 to 9 of 9

Thread: Hi Guys, I am new here I have a problem with if than

  1. #1

    Hi Guys, I am new here I have a problem with if than



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have an excel document, see attachment.

    When I fill the code in, is it possible to let excel fill in automaticlay the description and the price?

    See tab Artikel.

    Kind regards.

    Thanks!
    Attached Files Attached Files

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    plz see the attachment.
    Attached Files Attached Files

  3. #3
    Thank you very much!

    This is exactly what I was looking for.

  4. #4
    When I fill the rest of the cells with the formula, see attachemant, I am getting
    #N/B #N/B
    #N/B #N/B
    How can I put the formula in without these messages?
    Attached Files Attached Files

  5. #5
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    In B2 on "Artikel" sheet

    For Excel 2003
    Code:
    =IF(ISERROR(INDEX(Blad1!$B$2:$B$6;MATCH(Artikel!A2;Blad1!$A$2:$A$6;0)));"";INDEX(Blad1!$B$2:$B$6;MATCH(Artikel!A2;Blad1!$A$2:$A$6;0)))
    For Excel 2007 and later
    Code:
    =IFERROR(INDEX(Blad1!$B$2:$B$6;MATCH(Artikel!A2;Blad1!$A$2:$A$6;0));"")
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  6. #6
    Thanks Navic,

    I have tried this, see attachemant.

    I receive errors.
    Attached Files Attached Files

  7. #7
    Can anyone help me with this problem please?

  8. #8
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013

    How to remove error in Excel

    Quote Originally Posted by Archimadness View Post
    Can anyone help me with this problem please?
    You need remove ERROR. Here is your example
    Attached Files Attached Files
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  9. #9
    Thank you very much!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •