try to find formula for Lookup Function

Hey,

I'm trying to create a formula that I believe requires a Lookup function

It would be pretty difficult for me to describe on this post, so I just described what I'm looking for inside this spreadsheet

If you could take a look at it, I'd highly appreciate it

As always, Thank you SOOO much
Bob

Try:

=INDEX($G6:$Q6,MATCH(1,$F$20:$P$20,0))

or

=SUMIF($F$20:$P$20,1,$G6:$Q6)

copied down