Maybe it would be easier if you explained what you are trying to do instead
of asking people to audit a large array formula trying to figure out what
you want?


--
Regards,

Peo Sjoblom


"Mahadevan Swamy" wrote in message
ups.com...
How can I use VLOOKUP and MATCH functions to substitute this formula?

=SUM(IF('[Input.xls]Customer Returns (External)'!$A$3:$A$1200 = $C
$53,
IF('[Input.xls]Customer Returns (External)'!$C$3:$C$1200=C$54,
IF('[Input.xls]Customer Returns (External)'!$D$3:$D$1200 = $A57,
IF(ISBLANK('[Input.xls]Customer Returns (External)'!$J$3:$J$1200),
IF(ISBLANK('[Input.xls]Customer Returns (External)'!$I$3:$I$1200),
'[Input.xls]Customer Returns (External)'!$H$3:$H$1200,
'[Input.xls]Customer Returns (External)'!$I$3:$I$1200),
'[Input.xls]Customer Returns (External)'!$J$3:$J$1200)))))

Any ideas? Thanks in advance

Swamy