+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 18 of 18

Match Item with Invoice and Replace any missing Item AUTO

  1. #16
    Forum Contributor
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    351

    Re: Match Item with Invoice and Replace any missing Item AUTO

    there is no any possibility in excel?

  2. #17
    Forum Contributor
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    351

    Re: Match Item with Invoice and Replace any missing Item AUTO

    Hi,
    can is it possible to highlight items are not match to each other AUTO. it is easy to find out. in attached file,
    =IF(MATCH(A3,$F$3:$F$21,0)>0,A3,REPLACE(A3,1,11,F3)) shee1
    return #N/A why not replace when condition false.
    Thanks.
    Attached Files Attached Files

  3. #18
    Forum Contributor
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    351

    Re: Match Item with Invoice and Replace any missing Item AUTO

    Hi, can anybody tell me when condition false in last previous post, it would AUTO replace.
    =IF(MATCH(A3,$F$3:$F$21,0)>0,A3,REPLACE(A3,1,11,F3)) shee1 i use in K2.
    Thanks.

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

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