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

S

sand

Joined
Jun 23, 2005
Messages
3
Reaction score
0
Hi,

I have wriiten the following code.

Private Sub btnPastCommentsActivityList1_Click()
ActiveWorkbook.Sheets("Activity_Database").Activate
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 sheet for the value and assigns it to "txtOldComments".

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

I hope someone can help me thanx.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLookup problem...help pls...urgent 0
vlookup lookup different column 1
Bypass entry of data from Lookup Table 2
Help: How do I create a column of fixed width data? 1
Hide Columns Based On Date Value 1
can I use an update macro on multiple columns 2
Autosort multiple columns, Keep records intact. 4
Specifying a Command Button on a worksheet as differentiated from one on a UserForm 14

Back
Top