How to get cell values based on another cell value

[muthu.m]

Hi,

I need to get the values of cells, my excel like as below:

If A3 contains value 1, B3 contains 0 so then i need to get the value of A2 and assign to variables (StartDate & EndDate)
Like this E3,F3 and G3 contains value 1, so i need to get the value E2 and assign to the variable (StartDate) and get the value of G2 and assign to the variable (EndDate).

Pls advise logic for this…

Thanks in advance,
Muthu

[treesa.maria (Treesa Maria(Speridian Technologies))]

Hi @muthu.m,
Have a look at this:

How to get specific cell value from excel with value form another cell

Hello, first of all, this is a great community from which I got a lot of help in the past. I’m still not good with Excel though, so here is a question I have. I have an Excel sheet with 2 columns. I have the string value of one cell from column A in my clipboard (extracted from SAP) (f.e. A5) How do I get the value from the cell in the same row in column B (B5) as a string value? Appreciate all the help. Thanks, Dustin

[muthu.m]

Thanks for your response.
Could you please provide sample for my requirement.

Regards,
Muthu

[ManiPrajwal_K (Mani Prajwal Katta)]

@muthu.m… Does the excel cell values remain the same or will change according to the month?

[muthu.m]

Thanks for the response.

Values are change according to the every week.
Per sheet contains weekly details. This sample is for the 1st week for the month of November 2020.

Thanks in advance,
Muthu