Results 1 to 9 of 9

Need help checking cells for correct values

Threaded View

  1. #2
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Need help checking cells for correct values

    Why troubling yourself in typing all these manually.
    Formulas can do that for you.

    Main formula cell--H3
    Each time you want to input labour rate, just copy the main formula cell and paste in the desired range.

    =INDEX(INDIRECT("Sheet2!C"&MATCH(LEFT($B3,FIND("/",$B3)-1),Sheet2!$A:$A,0)&":C10000"),MATCH(RIGHT($C3,LEN($C3)-FIND("/",$C3)),INDIRECT("Sheet2!B"&MATCH(LEFT($B3,FIND("/",$B3)-1),Sheet2!$A:$A,0)&":B10000"),0))
    Attached Files Attached Files
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Not returning correct values in all cells
    By maximpinto in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-16-2015, 12:41 PM
  2. [SOLVED] Checking code format is correct or not ?
    By makinmomb in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-10-2014, 03:52 PM
  3. [SOLVED] Calculating GST and Checking that the GST is correct
    By becca26031993 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2012, 11:34 PM
  4. Replies: 3
    Last Post: 06-27-2012, 05:47 PM
  5. checking whether a number of cells have values
    By LAazsx in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-05-2010, 09:47 PM
  6. Checking info against cells containing multiple values
    By systematic in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2005, 03:02 AM
  7. [SOLVED] Checking if a cell entry is correct before adding it to another
    By Zakynthos in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 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