HI,
Im having a slight problem here. I have two tables which both have two columns. One column has dates in it e.g. 01/09/04 and the second column has a number in it. What i am wanting to do is create a combo box that, when i select the date from the list, it brings up the number (that is in the cell next to it) and puts this number into the cell next to the combo box.
I know how to get the combo box and add the dates to the list, but i have no idea on how to bring the dates up.
I have tried creating a combo box with the dates and then formatting it to create a cell link. This link then brings up the first number of the date in the cell i have chosen. I have then selected a blank cell and entered the formula VLOOKUP(lookup_value,table_array,col_index_num) However, when i have tried this, it hasn't worked.
Sorry this is very long winded but if anyone could help i would be very grateful.
Thank you
Laura
Bookmarks