index/match function as vlookup for 2 columns

[chmielko]

Hello there !

I've searched throughout the forum, did find some answers to my question and think I've learned how to use index/match formula.

The thing is, there is still sth missing in my formula - it's really hard to explain it, so I will be really grateful if you can take a look at my working file - I bet that it won't take you more than 5 sec to see what is wrong with it

So what I wanna do is get the value from column "C" in 1st sheet and place it in column "C" in the 2nd sheet only if values from both column "A" and "B" from 2nd sheet are the same as column "A" and "B" from 1st sheet - sounds a bit complicated, but looks very simple in the file

Thanks a lot in advance

[tigeravatar]

chmielko,

In sheet "worksheet" in cell C2 I put the following formula:

Please Login or Register  to view this content.

Then just copy down. I have attached a modified version of your workbook so you can see how it works.

Hope that helps,
~tigeravatar

[chmielko]

WOW thanks a lot ! works perfectly

still a lot of learning infront of me I see !

Cheers

[martindwilson]

no need for indirect
=INDEX('import from here'!$C$1:$C$1000,MATCH(A2&B2,INDEX('import from here'!$A$1:$A$1000&'import from here'!$B$1:$B$1000,0),0))