How to put an IF & 2 VLOOKUP statements together

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
 

Forum statistics

Threads
1,077,977
Messages
5,337,506
Members
399,153
Latest member
Tsmith25

Some videos you may like

This Week's Hot Topics

Top