MillicentL
New Member
- Joined
- Aug 10, 2018
- Messages
- 1
Hi There
I am trying to look for a Y in two columns on multiple sheets and have a defined answer. Here is an abbreviated formula. It only works for sheet one?! Does not look at other sheets (There are 6).
=IFERROR(IFS(VLOOKUP($A10,'ZAM Calc'!$A$3:$AZ$2000,13,FALSE)="Y","EME",(VLOOKUP($A10,'ZAM Calc'!$A$3:$AZ$2000,14,FALSE)="Y"),"QME",(VLOOKUP($A10,'ZAY Calc'!$A$3:$AZ$2000,13,FALSE)="Y"),"EME",(VLOOKUP($A10,'ZAY Calc'!$A$3:$AZ$2000,14,FALSE)="Y"),"QME"),"Gen")
PLease please help![Eek! :eek: :eek:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Millicent
I am trying to look for a Y in two columns on multiple sheets and have a defined answer. Here is an abbreviated formula. It only works for sheet one?! Does not look at other sheets (There are 6).
=IFERROR(IFS(VLOOKUP($A10,'ZAM Calc'!$A$3:$AZ$2000,13,FALSE)="Y","EME",(VLOOKUP($A10,'ZAM Calc'!$A$3:$AZ$2000,14,FALSE)="Y"),"QME",(VLOOKUP($A10,'ZAY Calc'!$A$3:$AZ$2000,13,FALSE)="Y"),"EME",(VLOOKUP($A10,'ZAY Calc'!$A$3:$AZ$2000,14,FALSE)="Y"),"QME"),"Gen")
PLease please help
Millicent