Quote:
Originally Posted by davesexcel
Use
=INDEX(Sheet2!$C$2:$C$29,MATCH(1,(A2=Sheet2!$A$2:$ A$29)*(B2=Sheet2!$B$2:$B$29),0))
This is an array formula.
You will have to confirm with Ctrl & Shift & Enter.
Paste this into C2 and then click in the formula bar and then Ctrl & Shift & Enter.
This puts {} around the formula.
You can then drag the formula down.
|
in the same way
in one sheet only colomn i have code
from second sheet i have country, capital, code
i want in first sheet using code i want get country name, capital from second