Vlookup

[cortex10101]

Hi,

I think this is a VLOOKUP problem.

I have a list of client names in column A. I then have 2 other columns (E & H) with separate dates in the future that tell me the date the client needs contacting.

I would like to create another column on a separate sheet that shows all the clients that need contacting when either of those two date columns (E or H) match today's date.

How is this done?

Thanks in advance

 

[SteveO59L]

Re: VLOOKUP Help

why cant you filter cols e & h for todays date?

 

[cortex10101]

Re: VLOOKUP Help

why cant you filter cols e & h for todays date?

I wanted to compile this data and several other things from other workbooks onto a different sheet rather than working within the same sheet where there is a lot of superfluous data.

Sorry, should have been clearer.

 

[SteveO59L]

Re: VLOOKUP Help

are the dates in cols e & h ever likely to both be the same date?

 

[cortex10101]

Re: VLOOKUP Help

are the dates in cols e & h ever likely to both be the same date?

Yep there will be dates in the two columns which will be the same. There won't be on the same row but E and H could have the same date for different clients.

 

[cortex10101]

Re: VLOOKUP Help

Yep there will be dates in the two columns which will be the same. There won't be on the same row but E and H could have the same date for different clients.

For example row 2 could have today's date in column E and row 3 could have today's date in column H

 

[SteveO59L]

Re: VLOOKUP Help

something along the lines of
Dim lr As Long
Dim c As Range, rng
Dim val_1 As String
Sheets("sheet1").Activate
lr = Range("a" & Rows.Count).End(xlUp).Row
Set rng = Range("e2:e" & lr)
For Each c In rng
Sheets("sheet1").Activate
If c.Value = Range("e1").Value Or c.Offset(0, 3).Value = Range("e1").Value Then
val_1 = c.Offset(0, -4).Value
Sheets("sheet2").Activate
lr = Range("a" & Rows.Count).End(xlUp).Row + 1
Range("a" & lr) = val_1
End If
Next c