| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I am a little confused with the VLOOKUP results I am getting....
I have the following
=VLOOKUP(E2,'Finished Results'!E:F,1,FALSE) It is working fine, just I am not getting quite the results I was expecting! According to the help, I should have the ref table sorted by the feild I am looking for. In this case, even with out it sorted, I seem to be getting the correct results! Am I missing something here? Do I need to sort the data? Is there something wrong in the help file? Thanks Phil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum the results of a vlookup | Excel Worksheet Functions | |||
| IF/VLOOKUP with #N/A results | Excel Discussion (Misc queries) | |||
| Vlookup with two results | Excel Discussion (Misc queries) | |||
| Confused on what to use ????? vlookup with different criteria | Excel Worksheet Functions | |||
| Match, Index, Vlookup, If (confused) | Excel Discussion (Misc queries) | |||
Threaded Mode
