Hi,

A1:A19 is the area where you are searching,

B1 is the value to be (approximately) found

C1 is helper (displays the minimal distance between what you are searrching for and what is present in the data)

D1 is the closest value that has been found

Please read my signature at the bottom.

Best,

J.Ty.

Sheet1

A B C D 1 16 15 1 16 2 19 3 26 4 8 5 26 6 17 7 26

Spreadsheet Formulas

Cell Formula A1 =RANDBETWEEN(1;30) C1 {=MIN(ABS(A1:A19-B1))} D1 =IFERROR(VLOOKUP(B1+C1;A1:A19;1;FALSE);B1-C1) A2 =RANDBETWEEN(1;30) A3 =RANDBETWEEN(1;30) A4 =RANDBETWEEN(1;30) A5 =RANDBETWEEN(1;30) A6 =RANDBETWEEN(1;30) A7 =RANDBETWEEN(1;30) Formula Array:

Produce enclosing { } by entering

formula with CTRL+SHIFT+ENTER!

Excel tables to the web >> Excel Jeanie HTML 4

## Like this thread? Share it with others