Formula for multiple conditions only returns values for first condition

I am trying to fix a formula and it's driving me mad.

I have a spreasheet with several tabs. On one tab I have a list of names with the values 1 or 2 alongside them.

On another tab I have a set of values for each entry.

Tab 1
Ben 1
Bob 2
Tom 1
Sam 3

Tab 2
Ben 3 4 6
Bob 3 5
Tom 4 5 7
Sam 4

I need the formula to calculate the 3rd-1st value on tab 2 when the tab 1 value is 1, the 3rd-2nd value on tab 2 when the tab 1 value is 2 and to show no value when the tab 1 value is 3.

I've so far got:

Please Login or Register  to view this content.

But it only works for the first condition. Any help greatly appreciated as I am fairly new to excel and am trying to teach myself. :-)

[Hi and welcome to the forum

B]Administrative Note:[/B]

• We would love to help you with your query, but first, before we can proceed…
• Please see Forum Rule #1 about proper thread title
• Please PM me when complete and this post will be removed which will reset the replies to zero…
  
  To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title

I can't say I can solve your issue but, if it is returning the first result and stops that is because it found that result then stopped. You may need to incorporate AND into your equation. If(and(condition1, condition2, etc))
To get more help you might have to post an example worksheet with your desired results.