ExcelBanter - auto selection

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - auto selection (https://www.excelbanter.com/excel-worksheet-functions/147778-auto-selection.html)

If I have a worksheet with the following info 1 2 3 4

200 80
180 500

and I give the the following info
90
490
180
201
can I get a formula to lookup the value closely to number mentioned, from
the list and enter under the number (eg 200 = 201)

Your list, be it horizontal or vertical, must be sorted in ascending order,
then either the HLOOKUP or the VLOOKUP formulas using the "TRUE" option at
the end will return the number just lower than the criteria.....

hth
Vaya con Dios,
Chuck, CABGx3

"ekkeindoha" wrote:

If I have a worksheet with the following info 1 2 3 4

200 80
180 500

and I give the the following info
90
490
180
201
can I get a formula to lookup the value closely to number mentioned, from
the list and enter under the number (eg 200 = 201)