+ Reply to Thread
Results 1 to 4 of 4

Formula required for return the product item code from another sheet.

  1. #1
    Forum Contributor
    Join Date
    08-19-2020
    Location
    Dubai
    MS-Off Ver
    Office365
    Posts
    131

    Formula required for return the product item code from another sheet.

    Hi,


    Formula help required for return the as it is product item code in sheet 1 from sheet 2 data input. if item code not available and not match with any product in the data input from sheet 2 then it will be return as a "NA".


    Sample file attached.


    Thanks in advance for help,
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Formula required for return the product item code from another sheet.

    Try this in B2 on Sheet1 and copy down.
    =IFERROR(INDEX(Sheet2!B:B,MATCH(A2,Sheet2!A:A,0)),"NA")

    BSB

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Formula required for return the product item code from another sheet.

    A simple

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    will suffice. If you don't want the #N/A to show then wrap it in an IFERROR() function
    Last edited by Richard Buttrey; 09-07-2020 at 07:57 AM.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2019 H: 365
    Posts
    940

    Re: Formula required for return the product item code from another sheet.

    Hi Mohammad Munawar,

    Paste the following into cell B2 and copy it down.

    =IFNA(VLOOKUP(A2,Sheet2!$A$2:$B$16,2,0),"NA")

    Regards,

    Snook

+ 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: 3
    Last Post: 06-24-2018, 02:32 PM
  2. Want to update stock sheet as and when i enter product code in invoice sheet
    By anilpatni1234 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-22-2017, 01:18 AM
  3. [SOLVED] Vba to match item description and copy/paste item code to other sheet
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2017, 11:29 AM
  4. VBA code to create pivot for single pivot item, if required item is not available cre
    By Ishwarind in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-04-2016, 11:06 AM
  5. To get desired data in master sheet by selecting required item in drop down list
    By vmjain84 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-09-2016, 03:33 PM
  6. [SOLVED] HELP! VBA code for userform to return related item
    By MG3 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-18-2015, 01:57 PM
  7. Item Code created from Product Name and Color VBA
    By unclejemima in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-25-2013, 11:58 PM

Tags for this Thread

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