Sam,

It's kinda tough to nail down a moving target, you know ..

Anyway, for your new twist on it,
here's the irrefutable proof of how it looks like, & in working order:
http://www.freefilehosting.net/download/3kc8d
Multi Criteria Index Match.xls

In Sheet1,

I've array-entered* into B2:

=INDEX('BO Data'!$C$2:$C$655,
MATCH(1,
(TRIM('BO Data'!$E$2:$E$655)=TRIM('SAP BW Data'!D2))*
(TRIM('BO Data'!$F$2:$F$655)=TRIM('SAP BW Data'!B2))*
(TRIM('BO Data'!$G$2:$G$655)=TRIM('SAP BW Data'!A2))*
('BO Data'!$D$2:$D$655=8),0))

The above is the working formula, all in the same cell,
"decomposed" to make it simple to understand what's going on

*To array-enter means to press CTRL+SHIFT+ENTER to confirm the formula. You
gotta see Excel insert the curly braces: { } around the formula (look in the
formula bar) as proof that its correctly done.

P/s: I've watered down the range to just "$655" rows. Just use Edit
Replace to change the $655 to $65533 (your big range - but I suggest you
switch it to manual calc mode before doing this. Just press F9 to recalc.)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,400 Files:356 Subscribers:53
xdemechanik
---
"Sam" wrote:
Yes I verified I had the curlies. I even changed the data on the first row
to make sure all the data was the same in both files.

However, I have a new twist with the request that came up today.

Same workbook and cell definition as previous posting:

If Tab "DO Data" column E matches tab "SAP BW Data" column "D" and
"DO Data" column F matches tab "SAP BW Data" column B
and
"DO Data" column G matches tab "SAP BW Data column A
and
"DO Data" column D equals 8
then return "DO Data" column C

How will this change the formula you sent previously?

Thanks.