Results 1 to 4 of 4

Lookup,match few cells and return with customised words

Threaded View

  1. #1
    Registered User
    Join Date
    08-09-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2007/2010/365
    Posts
    82

    Question Lookup,match few cells and return with customised words

    I need help from the experts here. Had been cracking my head on how to do a check on Cell G2 of this sheet "Checking". We will first need to match the A2 of the same sheet with Column B in the master list on "Inv Master List", then compare the results for the header group FL, DN, TF and WH.

    We only need to return 2 results, OK and Unmatch and to fill a colour on the Unmatch cell. In order to match it, all data from the two groups must equal. If TF is 0, both TF needs to be 0 or blank. Need not necessary all fields have data.

    Hoped someone can help. Have a nice day.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] LookUP certain words and return back corresponding values
    By Excel Dumbo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-05-2013, 08:35 PM
  2. lookup or match - Return nearest match
    By devouk in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-05-2012, 06:11 AM
  3. [SOLVED] Match specific words in cell and return value if true or false
    By jbrooksia in forum Excel General
    Replies: 3
    Last Post: 03-27-2012, 04:15 PM
  4. Match words in cells
    By AndyTheAnimal in forum Excel General
    Replies: 8
    Last Post: 08-11-2010, 10:33 AM
  5. [SOLVED] How can I lookup cells that match a specific value and return all.
    By john in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-31-2005, 09:06 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