Index/Match/IF
 

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.

Index/Match/IF
 

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

michaelrkendrick wrote:
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.

Index/Match/IF
 

Did you leave out the !

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

--
Don Guillett
SalesAid Software

"michaelrkendrick" wrote in message
ups.com...
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.

Index/Match/IF
 

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

On Jan 23, 5:37 pm, "Don Guillett" wrote:
Did you leave out the !

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

--
Don Guillett
SalesAid Software
"michaelrkendrick" wrote in oglegroups.com...

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.

Index/Match/IF
 

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

--
Don Guillett
SalesAid Software

wrote in message
ups.com...
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

On Jan 23, 5:37 pm, "Don Guillett" wrote:
Did you leave out the !

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

--
Don Guillett
SalesAid Software
"michaelrkendrick"
wrote in
oglegroups.com...

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.