Lookup or find in excel help
Solved/Closed
Related:
- Lookup or find in excel help
- Https //accounts.google.com/sign in/v1/lookup - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Gif in excel - Guide
- Number to words in excel - Guide
- Kernel for excel repair - Download - Backup and recovery
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 14, 2010 at 05:06 AM
Dec 14, 2010 at 05:06 AM
in the first sheet (master sheet) in row 1 column 2 (that is cell B1) copy this formula
=VLOOKUP("*"&A1&"*",Sheet2!$A$1:$B$100,2,0)
you can copy B1 down
I assume there are less than 100 rows.
=VLOOKUP("*"&A1&"*",Sheet2!$A$1:$B$100,2,0)
you can copy B1 down
I assume there are less than 100 rows.