Index/Match/IF

[michaelrkendrick]

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.

 

[michaelrkendrick]

FYI - The Formula above (=Index(Worksheet1Etc...)) should appear to be
in B2, rather than A3, I hope this helps. Thanks again.

 

[Don Guillett]

Did you leave out the !

=Index(Woksheet1$B:$B,Match(A2,Worksheet1$A:$A))
=Index(Woksheet1!$B:$B,Match(A2,Worksheet1!$A:$A))

 

[kendrickmr]

Yes, I did leave out the !, sorry about that. Any thoughts on returning
only the cells that match "Yes" in Payments column, and not returning
values for the "No" in payments column. thanks guys

 

[Don Guillett]

Send a small sample workbook to me at the address below and I will take a
look.