Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
Seeking Improvement on excel function
Dear sir,
I have one question regarding an "index" formular together with "match". I used to set the following excel function to pick the data from the database: =INDEX("database",MATCH("column argument","column range",0),"target column range"). One of key thing of this excel funation is "target column range", which only allow to cover ONE column only. My question: Is there any way to improve or change the above excel function in order to make "target column range" can cover more column ranges. I have also thought about Vlookup and lookup function, but failed. Thanks for your advice, Wilchong -- Message posted via http://www.officekb.com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
improvement in cross reference system!! | Microsoft Word Help | |||
References Group Needs Improvement! | Microsoft Word Help | |||
Corrupting features, any improvement in 2007? | Microsoft Word Help | |||
Drawing Layer Operation Improvement | New Users |