If Else Formula Add

[VaYooper]

Hello.. I'm trying to figure out how to add a formula in 'Division Code' column that would vary based on the value in the 'Program' column. For example, if under 'Program' it contains either WH or ARM input this formula under Division code

=IF(ISERROR(VLOOKUP(H2,'Echelon Table'!A:B,2,FALSE))," ",VLOOKUP(H2,'Echelon Table'!A:B,2,FALSE))

if under Program' it contains PA then use this code

=IF(ISERROR(VLOOKUP(E3,'PA Extract'!E:G,3,FALSE))," ",VLOOKUP(E3,'PA Extract'!E:G,3,FALSE))

Trying to intertwine else statements and formulas always seems to confuse me. Thank you in advance

ID Number	Program	Group Code	Group Category	Control Number	Dept Code	Division Code	Group
5110001622205	WH			B0000000000001132677			GROUP 2
5110001622205	ARM			B0000000000001132677			GROUP 2
5110001622205	ARM			B0000000000001132677			GROUP 1
5110001867107	WH	D76302	CHISEL	B0000000000001129817			GROUP 3
5110001867107	WH	D76302	CHISEL	B0000000000001129817			GROUP 3
5110001867107	PA	D76302	CHISEL	B0000000000001129817			GROUP 3
5110001867107	WH	D76302	CHISEL	B0000000000001129817			GROUP 3
5110001867107	PA	D76302	CHISEL	B0000000000001129817			GROUP 3

 

[jasonb75]

Nothing in your post to say which column the 'Program' is in so I've assumed column B

=IF(OR(B2="WH",B2="ARM"),IFERROR(VLOOKUP(H2,'Echelon Table'!A:B,2,FALSE),""),IFERROR(VLOOKUP(E2,'PA Extract'!E:G,3,FALSE),""))

 

[VaYooper]

Nothing in your post to say which column the 'Program' is in so I've assumed column B

=IF(OR(B2="WH",B2="ARM"),IFERROR(VLOOKUP(H2,'Echelon Table'!A:B,2,FALSE),""),IFERROR(VLOOKUP(E2,'PA Extract'!E:G,3,FALSE),""))

Sorry about that. Yes it is in column B as assumed. You formula works beautifully Thanks!