Share via

Why is my indexing function not working?

Anonymous
2022-12-12T11:30:56+00:00

I am trying to sort of automate my spreadsheet so that is spits out the week commencing date of the following week using a table.

I'm using the indexing function to do this as I've done it to lookup values in a table previously and it has worked fine, however, on this I can't figure out what I'm doing wrong. Can anyone help? Open to other solutions also (Just no Macros or VBA please)

Here is what I have

Cells A:A have the following input: =IF(AND(B5>TODAY(),B5<=TODAY()+7),"Current","NA")

Thanks

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Rory Archibald 18,885 Reputation points Volunteer Moderator
2022-12-12T12:14:21+00:00

You need an exact match since your data is not sorted, so you should use MATCH(D2,Weeks!A2:A18,0). You don't need the second match at all since your INDEX range is one column.

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-12-12T11:34:45+00:00

    If I type "Current" into cell A3 it works, and gives me 12th Dec. Beyond that it seems broken

    Was this answer helpful?

    0 comments