#### dilleyo725

##### Board Regular
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.

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

Any suggestions on how to accomplish this?

### Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

#### TGroulx

##### New Member
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.

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

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

Replies
2
Views
283
Replies
2
Views
277
Replies
5
Views
344
Replies
0
Views
372
Replies
8
Views
262

1,190,807
Messages
5,983,026
Members
439,813
Latest member
monvarona

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back