Forum Discussion

scupacoffee's avatar
scupacoffee
Copper Contributor
Jan 15, 2021

Use displayed value in a cell rather than the input function, for use in another function?

Hello Excel community! This is my first time posting - and I do apologize if this is a repeat question.   First, a bit of background (though I will bold where my specific question starts)   Using...
excel
Formulas and Functions
office 365
training
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 15, 2021

scupacoffee 

Oh, such better to discuss with small sample file with only few records to illustrate an issue.

Do I understood correctly what in

match(LookUpDateCell+Time(8,0,0), LookUpDateColumn, 0)

you compare datetime lookup value with LookUpDateColumn which has only dates? If so, it could be

..match(INT(LookUpDateCell+Time(8,0,0)), LookUpDateColumn, 0)

Or LookUpDateColumn column is also  datetime and you try to find exact time for the date?

By the way, didn't check now but as I remember in Power Automate there is a function like ConvertTimeZone or so, you may do such conversions within it.

scupacoffee's avatar
scupacoffee
Copper Contributor
Jan 15, 2021

SergeiBaklan 

 

Hello again Sergei - your advice about the time zone conversion tool in Power Automate did the trick! 

I no longer need to use excel to convert between everything - so now it all works smoothly!

 

Thank you so much.

Resources