Forum Discussion

urb1985's avatar
urb1985
Copper Contributor
Aug 03, 2023
Solved

Formula and function

I am looknig for a formula where only the date change can pick the correspondant figure from the table for a particular material at a particular cell. example below;   PRODUCT NAME 5/14/2023 P...
excel
  • HansVogelaar's avatar
    HansVogelaar
    Aug 03, 2023

    urb1985 

    In B2:

    =INDEX(E2:O2,MATCH($B$1-DAY($B$1)+1,$E$1:$O$1,0))

    Fill down.

urb1985's avatar
urb1985
Copper Contributor
Aug 03, 2023
Thank you Bosinander for your help however unfortunately the provided formulas not working in my office, i am using Microsoft office 2013, can you drive formula for that version? many thanks.
HansVogelaar's avatar
HansVogelaar
MVP
Aug 03, 2023

urb1985 

In B2:

=INDEX(E2:O2,MATCH($B$1-DAY($B$1)+1,$E$1:$O$1,0))

Fill down.

  • urb1985's avatar
    urb1985
    Copper Contributor
    Aug 03, 2023
    This is working perfectly!

    Really Thankful.

Resources