Multiple IF(error Vlookup troubleshooting

[Kmitchell]

Hello All - the below formula does not work when F3 is T2042, G0299 or G0300. It does however work for the remaining codes that reside in column F. Is it the parenthesis placement? Or is it the placement of the =False statement?


=IF(IF(F3="T2042",L3,IF(OR(F3="G0299",F3="G0300"),IFERROR(VLOOKUP($O3,'MCAID FS'!$G:$I,3,0),IFERROR(VLOOKUP($P3,'MCAID FS'!$H:$I,2,0),IFERROR(VLOOKUP($Q3,'MCAID FS'!$G:$I,3,0),VLOOKUP($R3,'MCAID FS'!$H:$I,2,0))))))=FALSE,IFERROR(VLOOKUP($O3,'MCAID FS'!$G:$I,3,0),IFERROR(VLOOKUP($P3,'MCAID FS'!$H:$I,2,0),IFERROR(VLOOKUP($Q3,'MCAID FS'!$G:$I,3,0),VLOOKUP($R3,'MCAID FS'!$H:$I,2,0)))))*J3

 

[mole999]

Do you mean F3 = value G0299 or F3 = G0299

 

[Kmitchell]

yes, column F holds codes. If F3 or G3 = G0299 or G0300 then perform lookup without the multiplier *J3

 

[mole999]

so you are checking for a text value, remove the speech marks

 

[Kmitchell]

Awesome thank you so much!