Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup between multiple columns | Excel Worksheet Functions | |||
Lookup in multiple columns | Excel Worksheet Functions | |||
Lookup across multiple columns within multiple sheets | Excel Discussion (Misc queries) | |||
Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
lookup across multiple columns | Excel Worksheet Functions |