VlookUp

[taylorl]

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

[pinmaster]

Hi
Instead of a combo box try using a validation list. Select your first column and name it say...list1, then select both columns and name it say...list2. Then select the cell you want your list in then go to Data/Validation, from the drop down list choose List and type =list, now you can use a simple Vlookup to get your number.
=VLOOKUP(A1,list2,2,0)


Good Luck!
JG