| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
In the first sheet, next to your data, add the function:
=vlookup(B2, Sheet2!$A$2:$B$10,2,0) You can then sort by column C:C HTH Kostis Vezerides |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AUTO FILTER NOT CHANGING RESULTS | Excel Discussion (Misc queries) | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| FILTER ONE MULTIPLE SHEETS | Excel Worksheet Functions | |||
| How to make Bullen's FilterCriteria() data refresh real-time? | Excel Discussion (Misc queries) | |||
| Macro for Filter Switches ... Maybe??? | Excel Discussion (Misc queries) | |||
Threaded Mode
