Getting data from another worksheet
Closed
Rajat
-
Jun 24, 2012 at 01:50 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 25, 2012 at 02:16 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 25, 2012 at 02:16 AM
Related:
- Getting data from another worksheet
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- How to automatically transfer data between sheets in Excel - Guide
- Gta 5 data download for pc - Download - Action and adventure
- Digital data transmission - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jun 25, 2012 at 02:16 AM
Jun 25, 2012 at 02:16 AM
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
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
