Vlookup - how to sum two diferent column's

I have the following concern as i'm not able to solve it alone:

Ex: =vlookup(c11;flyingprogram;2+5;false)

kind regards

fausto

HOW CAN I SUM THE TWO COLUMNS FROM THE SPECIFIC TABLE??

Hi,

You'll need to double up the VLOOKUP. i.e.

Formula:

Please Login or Register  to view this content.

Or alternatively add a helper column to your lookup table which sums the 2nd & 5th columns and use the helper column in the VLOOKUP()

Ok, thank you, will try that helper….

HAVE TRIED THE HELPER BUT DOESN'T WORK, HAVE TRIED THIS AS WELL =SUM(VLOOKUP(AA33;FlyingProgram;2+3;FALSE)) BUT ONLY GIVES ME THE TOTAL NUMBER FROM THE SECOND CELL, SO STILL FAR FROM ANY SOLUTION...

KIND REGARDS
FAUSTO