Thread: Excel Help
View Single Post
  #18  
Old 1st May 2005, 01:07 PM
davez davez is offline
Member
 
Join Date: Jan 1970
Posts: 301
Thumbs up

dr ron, the easiest way probably is to use "lookup" functions, so in an unused area of the worksheet, for example at AA1 enter 0, AA2 enter .05 & so on, in cell AB1 enter 100, AB2 enter 90 & so on. then create a lookup function in cell I1 which will look something like this -

=LOOKUP(H1,AA$1:AA$11,AB$1:AB$11) & copy it down to cell I2 & so on.

basically it looks at the value in cell H1, finds that value in the cell range AA1 to AA11 & reports the value of the neighbouring cell in the range AB1 to AB11.

note that the ranges AA1 to AA11 & AB1 to AB11 will vary depending on how large your kg & points list is.

if the above makes no sense you are welcome to email me your spreadsheet & i will setup for you.

mango_madness@bigpond.com
Reply With Quote