multipule Vlookup in cell

[sunswan]

I am in need of some help. I understand the IF statement in its basic form, but I have come upon the need for a more complex statement.

In the work sheet I have two columns that have dates in them, (B1 and D1). What I am trying to do is have column U1 show B1 date, if it has a date. If no date in column B1 then show D1 date in column U1, if no date inB1 or D1 then column U1 needs to show current date.

I have a second request with this, how do I get an error message to show if I’m trying to enter a date in column D1 when a date is already there? I’m using VBA here.
Thanks in advance for the help.
Book1.xlsm

[etaf]

i cant answer the VBA

=IF(AND(B1="",D1=""),TODAY(),IF(AND(B1="",D1<>""),D1,B1))

[sunswan]

this will only show the B1 date or 01/00/00

[etaf]

worked OK for me

can you post a sample spreadsheet

[sunswan]

look in my first post, its book1.xlsm

[sunswan]

etaf, i'm sorry, I just looked at my first post and saw I didn't mention that I a'm using vlookup from cell A1 for my Datasearch. My mistake.

[etaf]

i'm not sure this is 100%
but is this the sort of thing you are after doing

=IF(AND(VLOOKUP(G6, $A$1:$D$9,2,FALSE)="",VLOOKUP(G6, $A$1:$D$9,4,FALSE)=""),TODAY(),IF(AND(VLOOKUP(G6, $A$1:$D$9,2,FALSE)="",VLOOKUP(G6, $A$1:$D$9,4,FALSE)=""),VLOOKUP(G6, $A$1:$D$9,4,FALSE),VLOOKUP(G6, $A$1:$D$9,2,FALSE)))

i may need to work on tomorrow (uk time zone)

[sunswan]

Solved it by myself using helper cell