Forum Discussion

groundwater's avatar
groundwater
Copper Contributor
Dec 16, 2022
Solved

XLOOKUP using other formula

Hi   I have a lot of data and I'm using the xlookup function. I want to know exactly what it is looking for.   My data has the date and time spread over a lot of columns so I've had to use formul...
  • Riny_van_Eekelen's avatar
    Dec 16, 2022

    groundwater It will work. XLOOKUP will use the result of the DATE/TIME formula. The picture below contains an example.

     

Resources