[KINNEY1978]

Office Version:Office 2007Operating System:Windows XP
0I need to combine the following to make a working formula for a large spreadsheet.

I only want to pull data where Column E = "STU" and Column B is EITHER "FTIC" or "TRANS".

('FA 08-20-10'!B:B="FTIC")

('FA 08-20-10'!B:B="TRANS")

('FA 08-20-10'!E:E="STU")

It needs to be incorporated into the following formula:

=INDEX('FA 08-20-10'!$M$2:INDEX('FA 08-20-10'!$M:$M,LastRow),MODE(IF(ISNUMBER(MATCH('FA 08-20-10'!$M$2:INDEX('FA 08-20-10'!$M:$M,LastRow),'FA 08-20-10'!$M$2:INDEX('FA 08-20-10'!$M:$M,LastRow),0)),MATCH('FA 08-20-10'!$M$2:INDEX('FA 08-20-10'!$M:$M,LastRow),'FA 08-20-10'!$M$2:INDEX('FA 08-20-10'!$M:$M,LastRow),0))))

I would GREATLY appreciate if someone can help me solve this! Thanks!

[Advertisements]

Not sure what you're doing but doesn't something like the following work?

=IF(AND(OR(colB="TRANS",colB="FTIC"),colE="STU"),do your formula,otherwise do something else)

[Vino Rosso]

Not sure what you're doing but doesn't something like the following work?

=IF(AND(OR(colB="TRANS",colB="FTIC"),colE="STU"),do your formula,otherwise do something else)