XLOOKUP and INDEX formulas in tandem

[SergeyZh]

Hi, could someone help me to figure out what is wrong in my formula?
Im trying to find a number closest to 0, regardless +/- in column K and return a number from a column F which at the same row. Column K should have some cells with #NUM! errors.
INDEX is meant to find a cell K281 (-52,3286927) and XLOOKUP should return a number 243000 from a cell F281, see attached image link
Capture.JPG

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

[Phuocam]

Try this:

=INDEX(F242:F362,MATCH(AGGREGATE(15,6,ABS(K242:K362)/(K242:K362<>""),1),ABS(K242:K362),0))

[SergeyZh]

Try this:

=INDEX(F242:F362,MATCH(AGGREGATE(15,6,ABS(K242:K362)/(K242:K362<>""),1),ABS(K242:K362),0))

Very appreciate you, it works like it should