Lookup from multiple columns....pls help...urgent...thanx
 

Hi,

I have wriiten the following code.

Private Sub btnPastCommentsActivityList1_Click()
ActiveWorkbook.Sheets("Activity_Database").Activat e
Range("C6").Select
txtOldComments.Value
Application.VLookup(cmbInitiativeDescription.Value , Range("C6:Z9999")
18, False)
End Sub

What the above does is that it looks up at the column C6 of the shee
for the value and assigns it to "txtOldComments".

However, how do I go about writing the code if i want to match bot
the cmbInitiativeDescription.Value and a date value that is in anothe
column (C12). However, the date is seperated into three field
(day,mth,year).

I hope someone can help me thanx

--
sandPosted from http://www.pcreview.co.uk/ newsgroup acces