Vlookup
Closed
Lost
-
Jul 4, 2009 at 03:05 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jul 4, 2009 at 11:03 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jul 4, 2009 at 11:03 PM
Related:
- Vlookup
- Transfer data from one excel worksheet to another automatically vlookup - Guide
- Vlookup if two cells match return value from third ✓ - Excel Forum
- Help Please IF & VLOOKUP Returns - Excel Forum
- Conditional Formatting in a vlookup - Excel Forum
- Vlookup to find missing data in 2 columns - Excel Forum
1 response
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jul 4, 2009 at 11:03 PM
Jul 4, 2009 at 11:03 PM
Hi Lost
Try =countif(a1,sheet1!A:A) in sheet 2 cell B1 and then sort/filter
Try =countif(a1,sheet1!A:A) in sheet 2 cell B1 and then sort/filter