lookup to latest date using MAX

[KDELGRECO]

so I have used this formula in the past and just tested on another worksheet and its working fine.. but for some reason in my existing 2 comparison files, this formula is only coming back #n/a and I cannot figure out why.

=MAX(IF('CC # to Customer Match'!$I$4:$I$3256='Customers with Card Changes'!D4,'CC # to Customer Match'!$E$4:$E$3256))

I am not sure if there is some formatting issue or what - help!!! please.

 

[Skybluekid]

You need to enter using Control+Shift+Enter as this is an array forumla.

 

[Skybluekid]

By the way, Welcome to the board

 

[KDELGRECO]

You need to enter using Control+Shift+Enter as this is an array forumla.

yes, should have mentioned that... I did do ctrl+shift+enter and the {} are appearing in my cell.

 

[Skybluekid]

Try =MAX(IF('CC # to Customer Match'!$I$4:$I$3256='Customers with Card Changes'!D4,'CC # to Customer Match'!$E$4:$E$3256)