Need a formula please?

[dilleyo725]

I'm looking for a formula to do the following and seem to be stuck.

I have a log that tracks merchants who have been approved. I want to track (on a separate sheet) ONLY the merchants who have been approved and the corresponding approval dates. So ideally, if I enter the information in sheet 1, and specify that "yes" the broker was approved in Col C, it will automatically update the list of approved merchants and the dates on sheet 2. I started by implementing an "IF" formula but the problem with that is that it produces gaps on sheet 2 based on a merchant is approved or not.

Column headers are as follows:

Col A = Date file received
Col B = merchant name
Col C = Approved?
Col D = Date approved

Any suggestions on how to accomplish this?

 

[TGroulx]

I'm looking for a formula to do the following and seem to be stuck.

I have a log that tracks merchants who have been approved. I want to track (on a separate sheet) ONLY the merchants who have been approved and the corresponding approval dates. So ideally, if I enter the information in sheet 1, and specify that "yes" the broker was approved in Col C, it will automatically update the list of approved merchants and the dates on sheet 2. I started by implementing an "IF" formula but the problem with that is that it produces gaps on sheet 2 based on a merchant is approved or not.

Column headers are as follows:

Col A = Date file received
Col B = merchant name
Col C = Approved?
Col D = Date approved

Any suggestions on how to accomplish this?

Only way I know how to do that without using VB is the following:

=IF(C2=TRUE,vlookup(B2,B$1:D$xx,1,False),False)

This would generate a list of Vendor names and of "False"s so you would not have any gaps.

 

[dilleyo725]

Is there way to even eliminate the "false" entries and avoid the gaps?