MATCHING THE DATA AND
Closed
CHETHAN
-
Nov 7, 2009 at 05:47 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 7, 2009 at 08:58 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 7, 2009 at 08:58 PM
Related:
- MATCHING THE DATA AND
- Tmobile data check - Guide
- We couldn't find an account matching the login info you entered ✓ - Facebook Forum
- Transfer data from one excel worksheet to another automatically - Guide
- Gta 5 data download for pc - Download - Action and adventure
- Data transmission cable - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 7, 2009 at 08:58 PM
Nov 7, 2009 at 08:58 PM
in the first file use VLOOKUP function
I am giving you a trivial example
in sheet 2 A1 to B5 is
name pan
a 1
s 2
d 3
f 4
in sheet 1
name pan
d
the Pan for d is not available here
in B2 type this formula
=VLOOKUP(A2,Sheet2!$A$1:$B$5,2,FALSE)
you will get 3
can you work on this If so confirm
read help under this fucntion
I am giving you a trivial example
in sheet 2 A1 to B5 is
name pan
a 1
s 2
d 3
f 4
in sheet 1
name pan
d
the Pan for d is not available here
in B2 type this formula
=VLOOKUP(A2,Sheet2!$A$1:$B$5,2,FALSE)
you will get 3
can you work on this If so confirm
read help under this fucntion