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.

"Max" wrote:

"Sam" wrote:
I think we are getting closer. I followed your instructions.
Now it returns #N/A.

Darn, it should have worked. Unless there's really no match found for the 3
lookup values specified.

Maybe re-check your *array-entering* of the formula? Did you see the curlies
in the formula bar, after you confirmed the array-entry? It's quite common
for us to rush through the CSE confirmation in a bid to get the formula
working. If the formula is not correctly array-entered, it'll just return
#N/A despite there being an obvious match.

Post back your findings ..
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,400 Files:356 Subscribers:53
xdemechanik
---