Lookups

[uul]

Hi all,

I am trying to put a lookup together that has numerous dates on a sheet and under these dates has the relevant data. This is a rolling document, so as we go on in the year, the dates get lower in the rows.

So what i am requiring is a forumla, that would look for say the date 24th Sept anywhere on the page, and when it finds it, give me the value of the cell underneath.

I would like the forumula to encompass this text "number for last 7 days is ...(this would be the value of the lookup under the relevant date)

Hope this makes sense.

Kind regards

 

[prasaddn]

Hi,

I am not clear of your requirements, but based on little what I have understood, you can use HLookUp formula to get whatever desired values beneath the date searched.

And, you concatenate function to add "number for last 7 days is " & Hlookup().

Regards,
Prasad DN

 

[uul]

Basically - its one sheet laid out like attached document, with numerous dates going back from1st January, and under each date is a set of numbers. I need a forumla that searches the whole sheet for the date required, then give me the value underneath.

 

[prasaddn]

if the date ae in specific row then you can still use the above said solution. In case the dates can come in any row of the entire sheet, then you need to use macros.

Regards,
Prasad DN

 

[uul]

well dont understand macros - thanks anyhow

 

[NARAYANK991]

Hi ,

See if the following helps.

Narayan

 

[uul]

Narayan you are the man - thankyou so much for this.

 

[uul]

I have attached the spreadsheet update as the formula doesnt work on multiple rows - see what you think - The spreadsheet shows how the data is laid out - so the forumula needs to check all dates in all coloums, find the stated date and then give me 1 cell below it.

Thanks again