Help with constructing an IF statement that indexes two columns for matching data.

[xiiro]

I apologize about my lack of excel knowledge. I am trying to teach myself as I go along and have come up with this solution to fix a greater problem. I am trying to figure out a way to type the following IF statement

=IF(INDEX Sheet1ColumnA&B at whatever length ColumnsA&B happen to be) Sheet1ColumnA&B=((Sheet3A2=Sheet1ColumnA)AND(Sheet3G1=Sheet1ColumnB)),TRUE"display the text in the cell, right of the positive match",FALSE "")

Essentially I am trying to automatically reference Sheet1 columns A&B. And where Sheet3A2 & Sheet3G1 = Cells A&B on Sheet1, display the data which exists in the related Sheet1 C cell, in Sheet3 G2.


I hope this makes sense and would appreciate any productive insight anyone can offer.

Thanks for reading.

[vlady]

welcome to the forum, maybe you could explain it better with a sample data include sample outputs.
To attach a sample workbook.

When you are in Advanced reply, click on the paperclip to open the upload window.

View Pic

[xiiro]

welcome to the forum, maybe you could explain it better with a sample data include sample outputs.
To attach a sample workbook.

When you are in Advanced reply, click on the paperclip to open the upload window.

View Pic

Here is the general idea of what I am trying to accomplish. SalonExample.xlsx

The data on Sheet 1 and 2 change daily so I need to reference them generally. I was thinking this could be accomplished by checking The ID and Service columns on Sheet 1 and matching them to the ID column and category title in Sheet 3.

[vlady]

i used index/match

SalonExample.xlsx

[xiiro]

i used index/match

Attachment 206892

Thank you so much! That definitely works in the example, but for some reason it isn't working with my actual worksheet. If I understand correctly, Your string:
=IFERROR(INDEX(Sheet1!$C$2:$C$11,MATCH(Sheet3!$A2&Sheet3!G$1,Sheet1!$A$2:$A$11&Sheet1!$B$2:$B$11,0)),"")

says the following:

=IFERROR(INDEX(*Sheet1 column range containing the desired results*,MATCH(*information in Sheet3 cell A1*&*information in Sheet3 cell G1*,*Sheet1 column range applying to data in Sheet3 cell A1*&*Column range applying to data in Sheet3 cell G1*,*exact match*)),*return blank if no match exists*)

I noticed there were a set of indexes on the bottom of Sheet3, but they didn't seem to be directly involved with the formulas in the table. Is there something obvious I seem to be overlooking?

[vlady]

you have to hit ctrl+shift+enter instead of just enter -> it's array formula you'll notice the formula will be enclosed with braces { =formula } if done right.

[xiiro]

You may be my most favorite person in the entire world! Thank you so much for taking the time to help me.

Have a great week,

=)

[vlady]

Thanks for the kind words, your very much welcome.

regards,
vladimir