Complex Lookup Formula

[LadyDi]

I have a table in my workbook that shows a low number column, a high number column, and a sigma column. I am trying to figure out a formula that will look in that table, find where a number would fall and return the sigma number for that row. For example, if my number is 49, the formula will look in the table, see that 49 falls between 41 (in the low number column) and 70 (in the high number column) and then return the sigma calculation of 5.3. Is there a way to do that?

 

[Trevor G]

One suggestion is to try out the index forumla. If you open your formula guide search the All section for Index then once highlighting it use the Help feature this should help you and show examples.

 

[chergh]

If your table is laid out low, high and sigma in colums a to c respectivley then the following formula should work:

=vlookup(49,A1:C100,3,true)