Excel issue
Closed
Kalyan
-
Dec 16, 2009 at 10:25 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 17, 2009 at 06:20 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 17, 2009 at 06:20 AM
Related:
- Excel issue
- Excel marksheet - Guide
- Excel apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Gif in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 17, 2009 at 06:20 AM
Dec 17, 2009 at 06:20 AM
in sheet1 in B2 copy paste this formula
=VLOOKUP(A2,Sheet2!$A$1:$B$100,2,FALSE)
copy B2 down.
note the dollar signs in the formula.
vlookup function is an useful function.read help on this function ine excel help
=VLOOKUP(A2,Sheet2!$A$1:$B$100,2,FALSE)
copy B2 down.
note the dollar signs in the formula.
vlookup function is an useful function.read help on this function ine excel help