Autofill based on different cell

[kevinjay1]

Hello,

I am looking for a way to autofill a cell on a different tab if the date is filled in. On sheet one in my example, I have a date (column A) that fills in if data is entered in a different cell (column B); The data represents days in this case. What I am looking for is a movable formula that will autofill in the appropriate cell on tab 2 in the correct cell and will move once data is entered on tab 1.

Example: I enter data in cell B7 on Sheet 1, I would like cell B3 on sheet 2 to autofill that number. The next day, a different number will be added in cell B8, I would like the autofill on sheet 2 cell B3 to reflect that change and to continue changing as data has been entered.

Is this possible without using vba? Is there a lookup formula I can use for this?

Thank you for looking, Kevinbacklog example.xlsx

[azumi]

Perhaps something like this?

[kevinjay1]

Oh My god, you are a genius, it is exactly like that. Thank you so very much azumi

That is a really complex formula, need to try and figure it out.

[azumi]

Yes you're welcome, glad it works....

[kevinjay1]

Okay, so I lied, I tried to make it fit for my actual sheet and cannot get it to fit in properly, I either get an error message stating my formula is incorrect or if I put 'around' the sheet name, I get a file save dialogue box that wants me to insert a file name. I did notice that it is an array and have been ctl-shift-entering

Here is what I am trying to input:

I have replaced everything step by step based off of the formula Azami provided but have a broken link somewhere. the second tab is where I am trying to insert this formula in column D. The new attachment is an exact copy of the worksheet I am using.

Please help?
Book3.xlsx

[azumi]

Yep something missing with your formula, check this out