Find the closest match

{=INDEX(CellRange,MATCH(SMALL(ABS(CellAddress - CellRange),1),ABS(CellAddress - CellRange),0))}


© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top