IF (function) is TRUE, LIST the corresponding values

[monicakp11]

I currently have an excel sheet with 5 columns. The first 4 have data, the last column has the function:

=IF(AND(D2<b3,d2>C3),A3,"")

So if (TRUE) the value in column D is between the values in columns B and C it prints the corresponding value from column A to column D. If (FALSE) the function will print a blank.

What I would like to do is somehow get this function to iterate over the entirety of columns B and C, and whenever true, add the corresponding value from A to a list in that cell in column D.
However, from my knowledge excel cannot list multiple items in a single cell. So my thoughts were to possibly create a table that would list all the column A values that fit the requirements of the function for the value in column D.

I am open to solutions in excel directly or even using excel macro. Any help would be greatly appreciated!</b3,d2>

 

[Michael M]

Firstly, unless you have had typo, the formula supplied won't work !
Then...
how does this apply to the formula provided, B isn't involved in the function ??

the value in column D is between the values in columns B and C it prints the corresponding value from column A to column D. If (FALSE) the function will print a blank.

 

[monicakp11]

Sorry, I'm not sure why my equation disappeared. It should be:

=IF(AND(D2<B3,D2>C3),A3,"")

"So if (TRUE) the value in column D is between the values in columns B and C it prints the corresponding value from column A to column D. If (FALSE) the function will print a blank."

 

[monicakp11]

Ok for some reason it deletes the equation.

= IF ( AND ( D2 < B3 , D2 > C3 ) , A3 ,"")