Forum Discussion

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
Aug 03, 2023
urb1985

In B2:

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

Fill down.

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

Copper Contributor

Aug 03, 2023

This is working perfectly!

Really Thankful.