Hello,

Is there a function that can sum multiple Vlookup results? I hate doing this to sum 3 Vlooukup results: =VLOOKUP($I3,AFFINITY,7,FALSE)+VLOOKUP($I3,AFFINIT Y,8,FALSE)+VLOOKUP($I3,AFFINITY,9,FALSE)

Thanks,
Gen

I'm not sure there is, but what is it about your posted method you find objectionable? If it works and is accurate, what problem does that leave for you?

looks good but you need to change it a little:

=SUM(VLOOKUP($I3,AFFINITY,7,FALSE)+VLOOKUP($I3,AFF INIT Y,8,FALSE)+VLOOKUP($I3,AFFINITY,9,FALSE))

Should do the trick ;)