You should ask this question in an Excel newsgroup. This one is for Word.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"wilchong via OfficeKB.com" u43231@uwe wrote in message
news:9ac0c33497006@uwe...
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