VBA help needed to Fill cell values based on Adjacent Cell values

Folks,

I request you to write a code for me to fill the cell values as "Not Applicable" in Column "AZ", if the "B" Column cell values = "Justified", "Approved LSAR" & "Approved SDAR".

I have attached the work book of what I am trying to accomplish.


Thanks in advance for your time and expertise.

Joshi

Is this an OR or And statement?

All options need to be forfilled, or 1 of the options result in the text "Not Applicable"

OR statement...

LIKE : =IF(OR(B1=""Justified", B1="Approved LSAR", B1= "Approved SDAR") then the returns should be "Not Applicable"

No need for VBA

You where on the right track.

=IF(OR(B2="Justified",B2="Approved LSAR", B2= "Approved SDAR"),"Not Applicabl","other text")

and drag down

oeldere,

I need a VBA code since this sheet contains huge data and the row data will vary always. And I don't want drag down the formula all the times. I have the below partial code already, please help me to fix these.

    Dim columnValues  As Range, i As Long
    Dim cellstart As Integer
    Dim cellend As Integer
    cellstart = 2
    cellend = ActiveSheet.Range("B" & ActiveSheet.Rows.Count).End(xlUp).Row

    i = 1

    For i = cellstart To cellend
        If Cells(i, 2).Value = "Justified*" Then '<------ PLEASE HELP ME TO ADD ANOTHER TWO MORE CONDITION HERE
            Cells(i, 52).Value = "Not Applicable"
        End If
    Next i

Thanks,
Joshi

Non VBA solution.

In that case make an table of your data.

After that use the formula I provided and it will expand to the last row of your table.

Oeldere,

Can you please help me to modify my existing code to fix this?

OR Someone please help me...pleaseeeeeeeeeee

Hi Joshi

How does Column B get changed/updated?

with an table and the given formula.

see the attached file.

Hi John,

Column B will have a drop down list to select these values. Hence the cell value in Column B will be unique all the time.

Thanks,
Joshi

and my solution in #8?

Oeldere,

I don't want any formula in AZ Column. Since there also will be some manual entries

What manual entries will be in column AZ?

In which cells?

Under which conditions?

Thank you so much AB33, this what I was looking for.

Oeldere and jaslake, thank you also for your reply, suggestions and help.