# Help with Formula formatting!

Copper Contributor

# Help with Formula formatting!

Hi, I have an excel problem and hopefully someone could help me. I wanted the column H to display the date from "Date of ASTS LTR". The criteria are if Column B matches the Column D and if Column B has "A (not bold)" from Column Q.

# Re: Help with Formula formatting!

To display the date from "Date of ASTS LTR" (column M) in column H based on your criteria, you can use a combination of the IF, INDEX, MATCH, and AND functions. Assuming your data starts from row 2, you can use the following formula in cell H2 and then drag it down:

=IF(AND(B2=D2,Q2="A (not bold)"), INDEX(M:M, MATCH(B2, D:D, 0)), "")

The formula must be adapted to the necessary cells in the columns.

Here is a breakdown of the formula:

• AND(B2=D2, Q2="A (not bold)"): Checks if column B matches column D and if column Q has the value "A (not bold)".
• INDEX(M:M, MATCH(B2, D:D, 0)): If the above condition is true, it uses MATCH to find the row number where B2 matches in column D, and then uses INDEX to retrieve the corresponding value from column M.
• IF(AND(...), ..., ""): Wraps everything in an IF statement to return an empty string ("") if the condition is not met.

Drag this formula down in column H, and it should display the date from "Date of ASTS LTR" based on your specified criteria. The text and steps were edited with the help of AI.

My answers are voluntary and without guarantee!