Excel 2007 : IF formula should ignore cases when comparing strings

[Sybie]

Hello everyone

I have a bit of a problem that I can't seem to work around.
I have 2 sheets, 1 original I can't modify and one I copy it to. On this copy I modify/extract data/manipulate data/...

However, since the new version of the original excel,, some headers have changed. Meaning that they changed the Cases (eg: NAME became Name; TYPE became type etc...)

I could change my headers to match them but than it would no longer be compatible with the previous "original" sheets.

My formula is:
=IF(AL$2=Copy!AL$2;Copy!AL4;INDEX(Copy!$A$1:$FZ$2000;ROWS($A$1:$A4);IFERROR(MATCH(AL$2;Copy!$A$2:$FZ$2;0);MATCH(AL$2;Copy!$A$3:$FZ$3;0))))

should make:
IF NAME = NAME (or name or Name or naME); INDEX(Copy!$A$1:$FZ$2000;ROWS($A$1:$A4);IFERROR(MATCH(NAME;(Name;NAME;naME) in Copy!$A$2:$FZ$2 or in Copy!$A$3:$FZ$3)

any help would be appreciated.

Kr

[Marcol]

Try substituting NAME with Upper(Name) where ever/how ever it is refered to in your formula, this might produce an array formula, if so then confirm with Ctrl+Shift+Enter