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

"Al" <[email protected]> wrote in message
news:[email protected]...
>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

[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)

Al wrote:
>
> 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

--

Dave Peterson

[Dave Peterson]

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

Al wrote:
>
> 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

--

Dave Peterson