If Then Formula

[gambinus2]

I have an If Then formula I am trying to create from one tab to another

The first attachment is a screen shot of my data entry page - data is entered in columns A, B, and C. The below formula drops info into column D:

=INDEX('All Lc''s'!$O$2:$O$3609,MATCH(1,SEARCH("*"&'All Lc''s'!$A$2:$A$3353&"*",B3),0))

I need to create a formula that states if 1 one 25 possibilities pops into column D, then I want that transaction to flow into a tab named just like what would pop into Column D.

Any thoughts?

[gambinus2]

So basically, the second screenshot is the tap. So if cell B1 in this tab shows up in Column D of the previous screen shot, then I need the dollar amount and date to filter to the tab.

[gambinus2]

Attached is an example with a spreadsheet. I am trying to get the info to flow from the data tab to the VPO tab.

So if the name in cell B1 of the VPO tab showed up in the Data tab in Column D then I would like the corresponding info to filter to the VPO tab

HELP!!!

[modytrane]

Look at the attached example.
Tab VPO has formulas to bring over data from Data Tab if B1 [VPO] shows up in column D of Data Tab.
Hope it helps.
modytrane.

[gambinus2]

Thank you, that is perfect!

Why is it when I copy and paste the formula from my Data tab down to where there is no data in Columns A, B, or C it will past the info from D and C rather than the formula?

[modytrane]

I don't really understand your question.
What seems to be the problem?
Attach your workbook and please explain where the problem is.
See the aatched workbook. I have dragged the formula in Data Tab down to Row 100 and on the VPO Tab the formulas are dragged down to Row 50.
modytrane.

[NBVC]

gambinus2,

I think this is the same question you posted here:

http://www.excelforum.com/excel-misc...en-sheets.html

If it is the same, please do not ask the same question in separate threads.. it wastes people valuable time.

[gambinus2]

This was very helpful and resolved my issue.

Thank you very much.