Getting data from another worksheet

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I am having 2 worksheets in a workbook

sheet1 consists of a data like this:

Country name Site engineer Name Contact Details
Benin ABC 111111111111
China BCD 222222222222
Japan CDE 33333333333


sheet2 consists of data like this:

Country name Site engineer Name Contact Details Problem Description




I have made a group of country name from sheet1 and select the country name in sheet2 from that group

now I want if i select country name then all the data in that particular row of sheet1 should be copied in sheet2.

I need it very badly.
Any help would be highly appreciated.

Thakns a lot in advance

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
in sheet 2 suppose in A2 you typed china
in B2 type this formula
=VLOOKUP($A2,Sheet1!$A$1:$C$100,COLUMN(B1),0)
copy B2 to C2

if col. c gives a different format reformat it as number with no decimal places
you can format the whole column C