| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Some rules about Vlookup
From help on VLOOKUP
VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup) Lookup_value is the value to be found in the first column of the array. Lookup_value can be a value, a reference, or a text string. Show us one of your formulas that works if a column is not first in the in the table_array. Gord Dibben MS Excel MVP On Mon, 25 Jan 2010 17:25:24 -0800 (PST), JohnC wrote: Most posts are about something that doesnt work ,This is about something that works but shouldn't work I have read in many places the vlookup only works with first column data -but I have tried it with other columns and it seems to work - What are the real rules for Vlookup ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I set up a validation rules with two data rules | Excel Worksheet Functions | |||
| How can I alter the rounding rules? | Excel Worksheet Functions | |||
| Basic Formula rules | Excel Worksheet Functions | |||
| Rules for Sheet names | Excel Discussion (Misc queries) | |||
| Exceptions to Validation Rules | Excel Worksheet Functions | |||
Threaded Mode
