i first sheet i have



country, capital (25 rows)

in second sheet ihave

country, capital, code (around 250 rows)


by looking in second sheet i want to add code to first sheet

Hi gsrikanth,

you will need to use a vlookup. If you upload the spreadsheet I can take you throught the steps to enter the formula.

plz find attachments

Attached Files

ADILABAD.xls (171.5 KB, 21 views)

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.

Hi gsrikanth,

davesexcel has given you a great solution to your problem however he didn't use the full ranges on sheet 2. Here is a minor correction to your problem.

=INDEX(Sheet2!$C$2:$C$1759,MATCH(1,(A2=Sheet2!$A$2 :$A$1759)*(B2=Sheet2!$B$2:$B$1759),0))

Again, follow the steps that he gave you and replace this formula with his.

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