IfAND help

[Hooah_Bath]

Hello. I created a VLOOKUP to find matches between 2 sheets in my workbook. For the cells without a match, it returned #N/A. I now need to get a formula to return these in another cell. I was trying something like this,
IF(A2="#N/A", Declined!B2, "Good") but I keep getting #N/A. Any help is greatly appreciated.

 

[shift-del]

Hi

Probably something like IFNA(A2),Declined!B2,"Good").

 

[AhoyNC]

Maybe one of these formulas will work for you.

Book1
	A	B	C	D	E
1	List 1	List 2	Not in list 2		Not in list 2
2	Frank	Bill			Mary
3	Bill	Frank			Jean
4	Mary	Fred	Mary		Kathy
5	Sam	Sam
6	Jean	Judy	Jean
7	Kathy		Kathy
Sheet1

Cell Formulas
Range	Formula
C2:C7	C2	=IF(ISERROR(VLOOKUP(A2,$B$2:$B$6,1,0)),A2,"")
E2:E7	E2	=IFERROR(INDEX($A$2:$A$7,AGGREGATE(15,6,(ROW($A$2:$A$7)-ROW($A$2)+1)/(ISNA(MATCH($B$2:$B$7,$A$2:$A$7,0))),ROWS($E$2:E2))),"")

 

[Hooah_Bath]

So I have tried all responses so far. It's not grabbing exactly what I want.
B2 from Sheet2 needs to look at the entire column of B in Sheet1 to see if there is a match. If so then it should say Good. If not then I need it to say what is in B2 from Sheet2.
I then need to copy this formula down to cover B2, B3, B4, and so on.

 

[shift-del]

=IF(ISNA(A2),Declined!B2,"Good"))

 

[Hooah_Bath]

I believe I figured it out using the info you two provided. Thanks a lot. I'll post the results tomorrow.