Vlookup issue

[alexic82]

Hi Guys

Hoping someone can help.

I setup this formula probably 3 years ago and i cannot for the life of me remember how I set it up.

Basically I am referring to two columns of data. one has a number that represents the day of the month, and one represents the amount of a bill.

I then refer to that all the way down a date list so that the bill amount is auto populated by the day number....if that makes sense.

anyway, the formula in the cells is =IFERROR(VLOOKUP(DAY($B1662),Recur,3,0),"")

I cannot remember where the source of 'Day' and 'Recur' is....i've looked everywhere.

Any ideas?

Thanks
Alexi

[kersplash]

Can you attach your sample workbook.

Go Advanced -> Manage Attachments -> Upload

[alexic82]

its got a bit of sensitive info in it...is there a way to send it just to you?

[:) Sixthsense :)]

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

[kersplash]

its got a bit of sensitive info in it...is there a way to send it just to you?

No. Just attach the relevant bits (desensitised of course).

[alexic82]

ok attached a redacted version

the data starts in S and T1

the blue column has the two formulas in it....

[alexic82]

basically i am just trying to find the data sources 'day' and 'recur' so i can copy them and use them for an additional list....just cannot remember. too many dead brain cells

[kersplash]

For the reference to Recur look in Formulas -> Name Manager.

DAY is an Excel function.
https://exceljet.net/excel-functions/excel-day-function

[alexic82]

woohoo!! thats it! thanks for that....

[AliGW]

For future reference, your thread title does not meet our forum requirements.

• Use concise, accurate thread titles.
  
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

Please ensure you use more meaningful thread titles in future. Thanks.