Vlookup all in one

[Al]

I have a database with dates in the first column and
formulas in the rest of the columns to the left.

How can i create a formula that will give me the date in
the first column if there is data to the right of the date.

Appreciate the help in advance.

Al

 

[L. Howard Kittle]

Hi Al,

I'm a bit confused with your post but will take a stab at it. I will assume
you have dates in the "first" column and I will call that column A. Now,
there can be no columns to the left of column A so I will further assume you
meant columns to the right as you indicated in the second paragraph.

So, with dates in A and data in B, C and D, try this formula in E and fill
down.

=IF(A1<>0,B1&" "&C1&" "&D1,"")

HTH
Regards,
Howard

 

[Dave Peterson]

You want it to look empty until you type something in B:IV of that row?

=if(counta(b1:iv1)=0,"",today())

(format as a date)

 

[Dave Peterson]

=if(counta(b1:iv1)=0,"",today())

I have a database with dates in the first column and
formulas in the rest of the columns to the left.

How can i create a formula that will give me the date in
the first column if there is data to the right of the date.

Appreciate the help in advance.

Al