Lookup formula

[1Bass]

Hello there,

ive used the following formula to change the cell value depending on time and it work but i want to modify it so it show another cell value depending on time

=LOOKUP(MOD(NOW(),1),0+{"08:00","09:00","10:00","11:00","12:00"},{"=D2","=D3","=D4","=D5","=D6"})

it show =D2 as text but i want to show the actual value (and it is a number) of cell D2 instead .. thanx in advance :]

 

[Peter_SSs]

Welcome to the MrExcel board!

Try ..

=LOOKUP(MOD(NOW(),1),0+{"08:00","09:00","10:00","11:00","12:00"},D2:D6)

 

[1Bass]

Welcome to the MrExcel board!

Try ..

=LOOKUP(MOD(NOW(),1),0+{"08:00","09:00","10:00","11:00","12:00"},D2:D6)

Thank you Mr Peter so much for helping.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.