I am working with 2 worksheets using the Index/Match function, but I
would also like to utilize the IF function in conjunction with that but
I am having problems. Here is what it looks like

Worksheet 1
A B C
Group Name Payment
Richmond John Yes
Charlottesville Bob No


Worksheet 2

A B
Group Name
Richmond
=Index(Woksheet1$B:$B,Match(A2,Worksheet1$A:$A))
Charlottesville
Louisa

This is a simplified version of I have going on, But I only want it to
Index/Match IF Payment (Worksheet1$C:$C) says YES. But I need to
reference the entire column, as I have many rows of Data.

I hope this crude depiction of my worksheets makes its way into the
Post in some visually pleasing manner, if not I apologize, any input on
this would be great, it is driving me nuts.