• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. V

    How to use vlookup on the output value of a formula?

    Sheet1: C2 value is output of a formula to concatenate A2 and B2 cell values. I am trying to use Vlookup and lookup C2 in Master data sheet. Again in Master Data sheet, A2 cell value is output of a formula. Below is the formula I am trying to use. =VLOOKUP(C2,'Master data'!A:D,4,FALSE) I...
  2. V

    Compare a parameter for a name across two different sheets and give an output message

    At any given point of time, two sheets of data to be compared. Either in same workbook or a different workbook. Attached is a file where there are 3 sheets of data. Instance1: For Sam in master sheet, compare the 'coverage %' with Sam in Coverage sheet and give the output as : Values match...
  3. V

    How to get numbers in a column to be classified in a range using formula

    How to get numbers in a column to be classified in a range using formula In column "A" I have numbers. In column "B" and "C" I have specified the desired outputs. Please let me know how to achieve this. I tried with IF condition using AND but it is not working and throwing error.
  4. V

    IF condition formula not giving any results

    =IF(AND(A3<TIME(18,0,0),A3>TIME(6,29,59)),"TRUE","FALSE") I am using the above formula and it is not working. Please check attached file. Not sure what the problem is.
  5. V

    A formula to satisfy a condition for a time range having date also

    Hi, I have a date and time column as follows: 08/01/2013 00:54:15 08/01/2013 08:03:01 08/01/2013 09:32:52 08/01/2013 13:03:43 08/01/2013 15:32:44 In the adjoining column, I need to satisfy a condition below: If the time is between 06:30:00 and 18:00:00 then it should return True, else False...
Back
Top