Hi and thanks for the help on my last thread here's my issue

I am trying to vlookup to another worksheet and sum the results from a set number of coloumns heres what I have so far

=SUM(VLOOKUP(A1989,'other work sheet'!$A$1:$IV$65536,{73,74,75},0))

This formula is only returning the value from coloumn "73" ? Help !!!