How to put an IF & 2 VLOOKUP statements together

[Steviefiege]

Hi,
This is one formula i have:

=IFERROR(VLOOKUP($B3,'Main Squad'!$A:$AM,MATCH(INDEX(Sheet1!C:C,ROW()),'Main Squad'!$A$17:$AM$17,0),0),"")

& this is another:

=IF(Table7[[#This Row],[POSITION]]="Goalkeeper",(VLOOKUP($B3,'Main Squad'!$A:$AM,MATCH(INDEX(Sheet1!$C$1:$O$1,),'Main Squad'!$A$1:$AM$1,0),0)))

How do i put them together to be one formula?
I want it to say that if the position is a 'Goalkeeper' to look at the 2nd formula, if it isn't then look at the first formula.

Rgs
Steve