Thread: auto selection
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ekkeindoha ekkeindoha is offline
external usenet poster
 
Posts: 46
Default 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)