nested VLookups with IFERROR

[Kmitchell]

Hello -

Any guidance on the below formula? There are two IFERROR lookups but I it is not working or changes the comma before the second IFERROR to a * and that does not give expected results. TIA!

=IF($N2="NS",$K2,IF(AND($N2="SB",$Q2="Y"),IFERROR(VLOOKUP($T2,'PCP Contractual FS'!$Q:$S,2,0),VLOOKUP($U2,'PCP Contractual FS'!$Q:$S,2,0)))),(IF(AND($N2="SB",$Q2="N"),IFERROR(VLOOKUP($T2,'SPEC Contractual FS '!$N:$P,2,0),VLOOKUP(U2,'SPEC Contractual FS '!$N:$P,2,0))))

 

[Special-K99]

NOTE: You have a space after references to "SPEC Contracutual FS" but not after "PCP Contractual FS"
Even if that's correct it's inconsistant with your sheet naming convention.

Shouldnt it be this?

=IF($N2="NS",$K2,IF(AND($N2="SB",$Q2="Y"),IFERROR(VLOOKUP($T2,'PCP Contractual FS'!$Q:$S,2,0),VLOOKUP($U2,'PCP Contractual FS'!$Q:$S,2,0)),IFERROR(VLOOKUP($T2,'SPEC Contractual FS'!$N:$P,2,0),VLOOKUP(U2,'SPEC Contractual FS'!$N:$P,2,0))))

 

[Kmitchell]

Thank you for your reply but I need to keep the two if(AND statements, I think your suggestion eliminated the one with the "N"

IF(AND($N2="SB",$Q2="Y")
IF(AND($N2="SB",$Q2="N")

 

[Special-K99]

I assumed I could leave out the other AND()

Perhaps

=IF($N2="NS",$K2,IF(AND($N2="SB",$Q2="Y"),IFERROR(VLOOKUP($T2,'PCP Contractual FS'!$Q:$S,2,0),VLOOKUP($U2,'PCP Contractual FS'!$Q:$S,2,0)),IF(AND($N2="SB",$Q2="N"),IFERROR(VLOOKUP($T2,'SPEC Contractual FS'!$N:$P,2,0),VLOOKUP(U2,'SPEC Contractual FS'!$N:$P,2,0)),"")))