Steviefiege
Board Regular
- Joined
- Aug 29, 2018
- Messages
- 66
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
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
