MS Excel - matching and extracting data
Closed
jryanp
Posts
1
Registration date
Wednesday December 15, 2010
Status
Member
Last seen
December 15, 2010
-
Dec 15, 2010 at 04:43 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 16, 2010 at 09:12 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 16, 2010 at 09:12 PM
Related:
- MS Excel - matching and extracting data
- Ms excel free download - Download - Spreadsheets
- Transfer data from one excel worksheet to another automatically - Guide
- Ms excel marksheet - Guide
- Tmobile data check - Guide
- Number to words in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 16, 2010 at 09:12 PM
Dec 16, 2010 at 09:12 PM
vlookup function will work. But normally vlook up table will be one sheet. if you want to vlookup at more than one sheet a macro is required. will you be comfortable with a macro
otherwise in four columns you can type vlookup formula for each sheet and three of them will be #N/A and one will give you the data.
choose your comfort level.
otherwise in four columns you can type vlookup formula for each sheet and three of them will be #N/A and one will give you the data.
choose your comfort level.