Search results

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...

Hi, Thank you for the above response. This is required because a manager gets a data in this fashion. He needs to quickly ensure that the parameter value is same and there is no error in the report. Check the file I attached. It is the closest I could get to arrive at a solution. Is there...

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...

It is either column B or column C that I needed the output as. IN column c, I wanted to get an output with a custom text that specify For eg: if the number is between 501 and 600 in a cell in column A, the output should be "oldest" or for that matter any text I specify.

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.

=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.

yes Narayan, you are right. Sorry about that. It was meant for xlstime who provided me with the solution

Hi Narayan, I am not sure whether you saw my last reply on this one. "Actually I saw that it is false for following when it should actually be true as it is between 06:30:00 and 18:00:00: 08/02/2013 08:11:05 FALSE"

Actually I saw that it is false for following when it should actually be true as it is between 06:30:00 and 18:00:0: 08/02/2013 08:11:05 FALSE

Works perfectly. Thanks a lot! However, I am curious to know how the formula works. Could you please breakup both the formulas for me so that I can understand how you achieved this and what was the logic you applied? Are there any conditions to be satisfied for the formula to work. Like...

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...

Hi Guys, I am Vijitkumar. I work as a team leader for a customer service process. I am still a learner and have joined this forum with the intention to learn more about Excel and VBA. Hopefully, I could someday contribute in small ways with any little knowledge that I possess about excel.