Lookup formula required?

[NeroM]

Okay, I'd be grateful if someone could help me with a formula to solve the problem below:

I have a table with in one tab where I want to put a date in cell A1, in the cells to the right on that row (B1, C1, D1, etc) I want a formula that will search the date that I've inserted in cell A1, then look for this date in an array of dates elsewhere that are organised as a column (lets say the array of dates starts in cell A11 (continues in A12, A13, A1 etc) and then insert the consecutive dates on from the first date.

A simple vlookup would normally suffice here, but the date that I insert in A1 could be anywhere in the lookup table.

(please ignore the attachment)

Thanks in advance.

[:) Sixthsense :)]

Instead of picture attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Pete_UK]

Attach a sample workbook - NOT a picture of part of one.

Pete

[NeroM]

Ok, I've attached a simple excel workbook that should illustrate my problem.

[:) Sixthsense :)]

In B1 Cell

=IFERROR(SMALL($A$10:$A$39,COUNTIF($A$10:$A$39,"<="&$A$1)+COLUMN(A:A)),"")

Drag it to right...

[NeroM]

Sixthsense, That works great when the two tables are on the same tab, but I need to have the two tables on seperate tabs & from your formula I can't fathom how to change the formula to still make it work.

[:) Sixthsense :)]

Just replace the ranges by selecting the ranges using the mouse.

[NeroM]

Aghh, sorry, still banging my head here. I've attached the spreadsheet that's stripped of sensitive data. In Cell E8 on tab 'EV dashboard' I have inserted my required start date, I have attempted to modify the formula in cell F8 & array. The data range that I want it to search on is G4:G9 on tab 'Periods'.

[:) Sixthsense :)]

In F8 Cell you used the below formula in which you mentioned COLUMN(F:F), but it should be COLUMN(A:A)

Your Current Error Formula on F8 Cell

=IFERROR(SMALL(Periods!$G$4:$G$94,COUNTIF(Periods!$G$4:$G$94,"<="&$E$8)+COLUMN(F:F)),"")

Corrected Formula for F8 Cell

=IFERROR(SMALL(Periods!$G$4:$G$94,COUNTIF(Periods!$G$4:$G$94,"<="&$E$8)+COLUMN(A:A)),"")