| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return a value from a list in another worksheet
oops youre right,but glad you sorted it out....
-- paul remove nospam for email addy! "mpanty" wrote: Thank you very much Paul! :) Worked like a charm! One thing you forgot however :P was to specify the "Col_index_num". The function is in fact with the format VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup) where Col_index_num is the column number in table_array from which the matching value must be returned. A col_index_num of 1 returns the value in the first column in table_array; a col_index_num of 2 returns the value in the second column in table_array, and so on. In my case, I needed "2". :) But thanks again! :D -- mpanty ------------------------------------------------------------------------ mpanty's Profile: http://www.excelforum.com/member.php...o&userid=21377 View this thread: http://www.excelforum.com/showthread...hreadid=501194 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| list worksheet macros/VBA without adding worksheet | Excel Discussion (Misc queries) | |||
| Return list of uncleared checks | Excel Worksheet Functions | |||
| form on one worksheet and the list on different worksheet | Excel Worksheet Functions | |||
| Selecting items from a list. To transfer to another worksheet? | Excel Discussion (Misc queries) | |||
| create a list of worksheet names (from a single folder, or open files) | Excel Discussion (Misc queries) | |||
Threaded Mode
