Results 1 to 15 of 15

Compare 2 work sheet cells and populate based on results

Threaded View

marimuthuravi Compare 2 work sheet cells... 06-01-2018, 01:25 AM
AliGW Re: Need help on excel formula 06-01-2018, 01:29 AM
marimuthuravi Re: Need help on excel formula 06-01-2018, 03:07 AM
David A Coop Re: Need help on excel formula 06-01-2018, 01:48 AM
AliGW Re: Compare 2 work sheet... 06-01-2018, 03:08 AM
Rev12 Re: Compare 2 work sheet... 06-01-2018, 03:34 AM
AliGW Re: Compare 2 work sheet... 06-01-2018, 08:09 AM
JohnTopley Re: Compare 2 work sheet... 06-01-2018, 08:49 AM
Rev12 Re: Compare 2 work sheet... 06-01-2018, 08:55 AM
marimuthuravi Re: Compare 2 work sheet... 06-01-2018, 10:44 AM
JohnTopley Re: Compare 2 work sheet... 06-01-2018, 11:12 AM
marimuthuravi Re: Compare 2 work sheet... 06-02-2018, 05:27 AM
JohnTopley Re: Compare 2 work sheet... 06-02-2018, 06:52 AM
marimuthuravi Re: Compare 2 work sheet... 06-01-2018, 07:32 AM
AliGW Re: Compare 2 work sheet... 06-01-2018, 08:58 AM
  1. #1
    Registered User
    Join Date
    05-08-2018
    Location
    Chennai
    MS-Off Ver
    365
    Posts
    34

    Compare 2 work sheet cells and populate based on results

    Can some one help me with simple formula to do below job for me?
    I have 2 work sheets

    Work sheet name : Claims. This has columns A till I

    How to populate I2 value

    When Cell A2 has value "Krish" or "Jacks", We need to apply below formula in I2
    Take cell H2 value in this Claims work sheet, Compare with cell A1 value in another work sheet called Reference
    If the values match, take C2 value in Reference work sheet and populate value in I2 of Claims work sheet
    If the value does not match, populate as "Offshore" in I2 of Claims work sheet
    When Cell A2 does not have value "Krish" or "Jacks", We need to mention "no match"
    Attached Files Attached Files
    Last edited by marimuthuravi; 06-01-2018 at 03:06 AM. Reason: title change

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA, User-defined formula argument referring to cell value calculated by Excel formula
    By ARAGORN II in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-23-2017, 01:57 PM
  2. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  3. Replies: 10
    Last Post: 12-16-2015, 03:16 PM
  4. Replies: 2
    Last Post: 03-21-2014, 11:43 AM
  5. Macro: Applying formula to multiple cells in excel (formula editing)
    By city in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-27-2012, 06:41 AM
  6. Replies: 0
    Last Post: 03-19-2012, 07:32 PM
  7. Replies: 1
    Last Post: 03-04-2012, 12:03 AM

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