auto selection
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)
|