Thread: complex lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Doug Doug is offline
external usenet poster
 
Posts: 460
Default complex lookup

I have a lookup table that I need to reference. based on a 3 digit # such as
"2.22", I need to be able to find the cross section on the lookup table.
Based on numbers across the top and down the left side;
If I have the number 2.22, it will return for me .15 from the table

lookup table (made up values)
.00 .01 .02 .03 .04 ... .09
2.0 .31 .32 .33 .34 .35 ... .50
2.1 .21 .35 .51 .51 .25 ... .85
2.2 .53 .52 .15 .52 .51 ... .81
2.3 .89 .58 .23 .45 .15 ... .15
--
Thank you!