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

JBeaucaire

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?

Curlyben

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