Is this a process that would need VBA?

[tballfst]

Basically, I am going to have an excel spreadsheet that will have two
columns and twenty to thirty rows. The two columns will be a column
that will have the numbers one to twenty, and the second one will be
black with the option of populating with an "x".

After the rows, there will be a blank area that I want to pull data
from another sheet depending on which rows have an "x" in them. I also
need to insert a page break after each true statement.

I have thought about using LOOKUP and/or IF statements, but neither
gets me the desired effect.

If this is confusing, send me an email and I can clarify in better
detail. Any help would be appreciated and thanks in advance.

Joe

 

[Patrick Smith [MSFT]]

The very nature of your need of a page break based on if something is true
would require a macro. However, aside from that requirement, a nested
VLookup in an If statement should get you what you are after. You'd check
first to see if the X exists in the cell and then if so, you do the vlookup.
If you need to test multiple cells for an X in one if statement, then you
group them together with an AND statement in the test portion of the If.

Hope this helps,