Forum Discussion
Search Function
Hi, I have an Excel worksheet with daily information such as interest rate, amortization, taxes, etc. On a separete worksheet I have just end of month dates and want to use a formula to fil...
- You probably need the VLOOKUP function. Suppose your daily sheet is called daily, containing data in A2:D100. And suppose you have a separate worksheet which has a date in column A, starting from row 2. Then this formula in cell B2 will return the interest rate belonging to that specific date:
=VLOOKUP(A2,Daily!$A$2:$D$100,2,FALSE)
(this formula only returns a value if the date which is in A2 ia found in the daily table)
You probably need the VLOOKUP function. Suppose your daily sheet is called daily, containing data in A2:D100. And suppose you have a separate worksheet which has a date in column A, starting from row 2. Then this formula in cell B2 will return the interest rate belonging to that specific date:
=VLOOKUP(A2,Daily!$A$2:$D$100,2,FALSE)
(this formula only returns a value if the date which is in A2 ia found in the daily table)
=VLOOKUP(A2,Daily!$A$2:$D$100,2,FALSE)
(this formula only returns a value if the date which is in A2 ia found in the daily table)
Thank you Jan Karel!