@cruzada_michelle
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!
Hope this will help you.
Was the answer useful? Mark as best response and Like it!
This will help all forum participants.
