Multiple IF VLookup Statment

Can anyone help me figure out why this isn't working? I'm trying to Vlookup values based on multiple criteria

=IF((L2="RADAR",VLOOKUP(D2,'RADAR GL FD_FR'!$B$1:$M$25191,1,FALSE)),
IF(L2="ATLAS",VLOOKUP(D2,'Webview GL April'!$D$1:$Q$10742,1,FALSE)),
IF(L2="DOGS",VLOOKUP(D2,'Webview GL April'!$D$1:$Q$10742,1,FALSE)),
IF(L2="GCS",VLOOKUP(D2,'Webview GL April'!$D$1:$Q$10742,1,FALSE)),
IF(L2="GSR_Exceptions",VLOOKUP(D2,'Webview GL April'!$D$1:$Q$10742,1,FALSE)),
IF(L2="IOWA",VLOOKUP(D2,'Webview GL April'!$C$1:$Q$10742,1,FALSE),0))

Hi,

You've got superfluous parentheses in each IF statement and insufficient closing parentheses. Try:

=IF(L2="RADAR",VLOOKUP(D2,'RADAR GL FD_FR'!$B$1:$M$25191,1,FALSE),IF(L2="ATLAS",VLOOKUP(D2,'Webview GL April'!$D$1:$Q$10742,1,FALSE),IF(L2="DOGS",VLOOKUP(D2,'Webview GL April'!$D$1:$Q$10742,1,FALSE),IF(L2="GCS",VLOOKUP(D2,'Webview GL April'!$D$1:$Q$10742,1,FALSE),IF(L2="GSR_Exceptions",VLOOKUP(D2,'Webview GL April'!$D$1:$Q$10742,1,FALSE),IF(L2="IOWA",VLOOKUP(D2,'Webview GL April'!$C$1:$Q$10742,1,FALSE),0))))))

Regards

ok great! thanks so much!