Simplify VLookup formula

[Mldeuser]

Hello

Is it possible to simplify my vlookup formula? Nothing will change when new information is entered into the utilities MO1 tab.

=VLOOKUP(B106,'Utilities MO1'!$B$2:$AH$38,5,FALSE)+VLOOKUP(B106,'Utilities MO1'!$B$2:$AH$38,6,FALSE)+VLOOKUP(B106,'Utilities MO1'!$B$2:$AH$38,7,FALSE)+VLOOKUP(B106,'Utilities MO1'!$B$2:$AH$38,8,FALSE)+VLOOKUP(B106,'Utilities MO1'!$B$2:$AH$38,10,FALSE)

Thank you

 

[jkpieterse]

Perhaps:

=SUM(VLOOKUP(B106,'Utilities MO1'!$B$2:$AH$38,{5,6,7,8,10},FALSE))

 

[Fluff]

Nothing will change when new information is entered into the utilities MO1 tab.

Does that mean the formula is not working?

 

[Mldeuser]

Formula works just wondered if there was a simpler formula

 

[Fluff]

In that case try Jan's idea, or

=SUM(XLOOKUP(B106,'Utilities MO1'!$B$2:$B$38,CHOOSECOLS('Utilities MO1'!$F$2:$K$38,1,2,3,4,7)))