Need to match and fetch data to 1st Sheet fro
Closed
madhu
-
Nov 9, 2011 at 02:47 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 9, 2011 at 07:06 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 9, 2011 at 07:06 AM
Related:
- Need to match and fetch data to 1st Sheet fro
- Google sheet right to left - Guide
- Little alchemy cheat sheet - Guide
- 1st mass mailer - Download - Email
- Transfer data from one excel worksheet to another automatically - Guide
- How to screenshot excel sheet - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 9, 2011 at 07:06 AM
Nov 9, 2011 at 07:06 AM
yes you can use vlookup
suppose sheet 1 like this
name mobile nol
a 1
s 2
d 3
f 4
g 5
sheet 2 is like this
name
a
d
g
in B2 in sheet 2 copy this formula
=VLOOKUP(A2,Sheet1!$A$1:$B$100,2,0)
you can copy B2 down
this will be ok for not more than 100 rows. if more rows are there modify that 100.
suppose sheet 1 like this
name mobile nol
a 1
s 2
d 3
f 4
g 5
sheet 2 is like this
name
a
d
g
in B2 in sheet 2 copy this formula
=VLOOKUP(A2,Sheet1!$A$1:$B$100,2,0)
you can copy B2 down
this will be ok for not more than 100 rows. if more rows are there modify that 100.
