Results 1 to 6 of 6

sheet one data compare with sheet two

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-14-2010
    Location
    oman
    MS-Off Ver
    Excel 2003
    Posts
    384

    Post sheet one data compare with sheet two

    dear friend my document first sheet column "K" data like this...
    column "K'
    125486
    526897
    458912A-B
    256897

    second sheet range A4 to G200 each column it like this....

    125486 / AS-28225 / 40/2 / TEXPORT O
    526897 / AS-28242 / 40/2 / TEXPORT O
    458912A / AS-28897 / 40/2 / TEXPORT O
    256897 / AS-28236 / 40/2 / TEXPORT O

    i need comparing formula to sheet one,column "K' values sheet two any columns available then "YES" it's not there "NO".i need to compare only column 'K' numbers.that last part (A-B) no need to check.pls make this formula for me....
    Last edited by johncena; 03-08-2010 at 09:52 AM.

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