Forum Discussion

BZED75's avatar
BZED75
Copper Contributor
Sep 02, 2022

IFTHEN help for a newbie trying new...

Hi everyone!  apologise for my ignorance in advance. I have a Large sheet (sheet a)  of raw data measurements in columns specified by points of depth in rows eg,  row1:  1.6m  , x , y , z , et...
excel
Formulas and Functions
dscheikey's avatar
dscheikey
Bronze Contributor
Sep 02, 2022

BZED75 

I can recommend the XLOOKUP() function for this. Here it would not matter if the numbers in the depth column are in sorted order. Otherwise you can also use VLOOKUP() or LOOKUP(). See my example file attached.