**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need to match 2 criterias (2 columns) from 2 excel sheets and if both the value match I want to return value from 3rd column. How can I do that? Please help.

Solved by D. S. in 44 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
23/05/2018 - 12:23

Hello, hope you are doing well

User
23/05/2018 - 12:23

hey

User
23/05/2018 - 12:23

m good hows you

Excelchat Expert
23/05/2018 - 12:24

So it seems like you would like to match two columns and then return a value if they match. Is that correct?

User
23/05/2018 - 12:24

yes but the vaslues are in different sheets

Excelchat Expert
23/05/2018 - 12:25

Do you have a file with the data?

User
23/05/2018 - 12:25

should i copy the values in excel?

User
23/05/2018 - 12:25

yes

Excelchat Expert
23/05/2018 - 12:25

You can attach the file to this chat

Excelchat Expert
23/05/2018 - 12:25

Can you try doing that?

Excelchat Expert
23/05/2018 - 12:26

Or you can copy the values in the two sheets here

Excelchat Expert
23/05/2018 - 12:26

Whichever is easiest for you

User
23/05/2018 - 12:27

did you received?

Excelchat Expert
23/05/2018 - 12:28

Hmm I do not see it attached here.

Excelchat Expert
23/05/2018 - 12:28

Maybe attempt to copy paste the values on this sheet

User
23/05/2018 - 12:30

check both sheets

Excelchat Expert
23/05/2018 - 12:30

Ok got it

User
23/05/2018 - 12:30

values in yellow i need to match and value in green i want as a result

Excelchat Expert
23/05/2018 - 12:30

Ok got it, and where would you like the result?

User
23/05/2018 - 12:30

in sheet 1

Excelchat Expert
23/05/2018 - 12:30

Column D of sheet 1

Excelchat Expert
23/05/2018 - 12:30

Got it

User
23/05/2018 - 12:30

yes

Excelchat Expert
23/05/2018 - 12:32

Ok give me one second while I solve

User
23/05/2018 - 12:32

ok

User
23/05/2018 - 12:35

this is just the part of my sheet so you can just send me a formula and i can try that in my worksheet.

Excelchat Expert
23/05/2018 - 12:37

Let me try downloading this sheet, I will tell you why in one second

User
23/05/2018 - 12:38

ok

Excelchat Expert
23/05/2018 - 12:41

Ok, so let me explain what I am doing while it is calculating and processing for me

Excelchat Expert
23/05/2018 - 12:42

So the idea is that we will be using an Index Match function

Excelchat Expert
23/05/2018 - 12:42

Where we use a series of match functions by using a multiplication between the criteria. If both criteria are met, then it will return column 1 of the array in sheet 2

User
23/05/2018 - 12:42

yeah i tried the same but am not an expert with that so it reuturned an error

Excelchat Expert
23/05/2018 - 12:44

Ok so this should be the equation you put into D2 of sheet 1:

Excelchat Expert
23/05/2018 - 12:44

=INDEX(Sheet2!A1:H2000,MATCH(1,(Sheet2!H:H=Sheet1!C2)*(Sheet2!C:C=Sheet1!A2),0),1)

Excelchat Expert
23/05/2018 - 12:44

After you paste that in, press:

Excelchat Expert
23/05/2018 - 12:45

Control Shift Enter

Excelchat Expert
23/05/2018 - 12:45

At the same time

User
23/05/2018 - 12:49

i wm not getting

User
23/05/2018 - 12:51

?

Excelchat Expert
23/05/2018 - 12:51

Ok so let me try something else for you

Excelchat Expert
23/05/2018 - 12:54

Hmm, try changing all the data into "Text"

Excelchat Expert
23/05/2018 - 12:54

this may be affecting it

User
23/05/2018 - 12:55

in the sheet?

Excelchat Expert
23/05/2018 - 12:55

Yes

User
23/05/2018 - 12:56

can you show me in the sheet

Excelchat Expert
23/05/2018 - 12:56

Highlight all the data, and then right now it should be as "General"

Excelchat Expert
23/05/2018 - 12:56

Click down on the menu and select "Text"

Excelchat Expert
23/05/2018 - 01:00

Any luck?

Excelchat Expert
23/05/2018 - 01:01

Because there is data missing from this file it may not be viewable on this file and only on yours

Excelchat Expert
23/05/2018 - 01:02

And make sure to use Control + Shift + Enter

Excelchat Expert
23/05/2018 - 01:02

as this is the only way that the data will work

User
23/05/2018 - 01:02

okay thanks i will try

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*