returning a row of information

**Ricardo9211** · 08-08-2009, 07:08 PM

Hello all,
i was trying to see or figure out if there is a way to bring over information on a row from one sheet to another. I have a sheet with dates in column A and information going across to column h.
as an example i have row 1 that has date in A1, text B1, text C1, nothing in D1 but text in E1 all in Sheet 1.
I want to see if there is a formula that will say if it is todays date then grab that row and bring over the row with the cells that have data

can someone let me know if this can be done

Thanks

**Palmetto** · 08-08-2009, 07:48 PM

If sheet1 is the source sheet and sheet2 is the sheet in which to return the look up, then something like this, assuming dates are in column-A and are unique (no duplicates):

=VLOOKUP(TODAY(),Sheet1!A1:D1,2,0)

Copied across and the look up index (third argument) adjusted accordingly. See Excel help on the VLOOKUP function.

Adjust the look up range in the formula as required - better yet, create a dynamic named range for the source data and use the name as the range reference.

**Ricardo9211** · 08-08-2009, 07:59 PM

thank you very much i appreciate it.

This works and gives me the values in the cells but when there is nothing in the cell it gives me a date of 1/00/00 is there any way around this

returning a row of information

LinkBack

Thread Tools

Rate This Thread

Display

returning a row of information

Re: returning a row of information

Re: returning a row of information

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions