+ Reply to Thread
Results 1 to 2 of 2

Excel-Formula Map with the description of another sheet

  1. #1
    Forum Contributor
    Join Date
    02-19-2014
    Location
    NJ
    MS-Off Ver
    Excel 2010
    Posts
    308

    Excel-Formula Map with the description of another sheet

    Hi ,

    Im trying to map the cases present in the sheet 1 to Sheet 2. Here the sheet2 I have highlighted the rows yellow color that needs to be updated by using excel formulas.Here the sheet should be updated with the description below mentioned along with the formulas..Highlighted cells in the sheet2 is B,C,I,J,T,U. I have designed the below condition in the same order


    B cells should be updated with the refernce of Sheet1 with the below condition:

    Identify the "(B Value)"Claim with below condition (D Value)

    C cells should be updated with the refernce of Sheet1 with the below condition:

    Verify wether (I Value) Mapped to the below Coverage in CAS (K value)


    C cells should be updated with the refernce of Sheet1 with the below condition:

    Verify wether the Incident (Q value)is below for the Coverage (K Value)

    J cells should be updated with the refernce of Sheet1 with the below condition:


    Verrify the the Exposure type(P) is below for the Coverage (K)

    T cells should be updated with the refernce of Sheet1 with the below condition:
    Verify the cost created the reserve coverage (K value) is below (N value)


    U cells should be updated with the refernce of Sheet1 with the below condition:

    verify the line category of the payment done on the coverage


    (X value of all the conditions for Sheet1 value)


    Thanks in advance,
    Lax
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    02-19-2014
    Location
    NJ
    MS-Off Ver
    Excel 2010
    Posts
    308

    Re: Excel-Formula Map with the description of another sheet

    Anyone...have any idea..Pls share your valuable logic here..

+ 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. Value from one sheet to another sheet, according to description, date n month
    By beneesetas14 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-13-2014, 04:28 AM
  2. Pull google results - title, description,url into excel sheet using VBA
    By joewhyte in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2013, 09:53 PM
  3. [SOLVED] If Text Description matches info on w/sheet then enter corresponding $
    By marsham in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-10-2013, 01:31 AM
  4. [SOLVED] Getting data from another sheet using dates & description as criteria.
    By Fotis1991 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-27-2012, 11:16 AM
  5. copy description from sheet 1 to sheet 2
    By MeloReese in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-06-2012, 01:53 PM

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