On 2002-04-27 09:30, Craig AS wrote:
ok
first combo box - cell link is B29 and its value is 1
second combo box - cell link C29 its value is 12, but i have a vloopup formaula which looks up this number and then displays the relevent month, so in this cell(C27) it says dec.
third combo box - cell link is D29, its vale is 1, but again i have used a lookup formula, and so in cell D28 it displays 2002.
and yes i did make the combo box from the forms toolbar. Hope this is what u wanted.
Craig
What follows what we logically should do:
=DATE(INDEX(Range3,D29),INDEX(Range2,C29),INDEX(Range1,B29))
where Range3 is the Input range of your 3rd combobox (apparently, consisting of 2002,2003,etc), Range2 is the Input range of your 2nd combobox (apparently consisting of 1,2,3,4,... up to 12), and Range1 is the Input range of your 1st combobox (apparently consisting of 1,2,3,... up to 31).
Notice that INDEX does exactly what you do with VLOOKUP.
However, we can shorten the above formula, given the regularity of your Input ranges, just to:
=DATE(INDEX(Range3,D29),C29,B29)
Custom format the cell of the formula as e.g.,
dd-mmm-yy
Aladin
This message was edited by Aladin Akyurek on 2002-04-27 10:07