Excel issue
Closed
Kalyan
-
16 Dec 2009 à 10:25
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 17 Dec 2009 à 06:20
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 17 Dec 2009 à 06:20
Related:
- Excel issue
- Excel mod apk for pc - Download - Spreadsheets
- Vat calculation excel - Guide
- Kernel for excel repair - Download - Backup and recovery
- Arrow keys not working in excel - Guide
- Excel clear formatting - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
17 Dec 2009 à 06:20
17 Dec 2009 à 06:20
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
