Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP always required the searching field SORTED?
Please help,
If a worksheet with A, B, C & D fields, so when VLOOPUP every time switching (looking) from field A to D, or to C then sorting to that perticular field is needed? Is there any better solution ? thank so much! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP always required the searching field SORTED?
If the 4th argument of the VLOOKUP is FALSE, sorting is not necessary. VLOOKUP will then look for an exact match and be slower,
which you may or may not notice, depending on the table size. -- Kind regards, Niek Otten Microsoft MVP - Excel "Johan2000" wrote in message ... | Please help, | | If a worksheet with A, B, C & D fields, so | when VLOOPUP every time switching (looking) | from field A to D, or to C then sorting to | that perticular field is needed? | | Is there any better solution ? | | thank so much! | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can data be sorted by the length in a field | Excel Worksheet Functions | |||
Pivot Table Field Values not sorted | Excel Discussion (Misc queries) | |||
Copy table information and paste sorted based on specific field. | Excel Programming | |||
searching on more than one field in VB | Excel Programming | |||
Field Required if another field is checked | Excel Programming |