I&#039m stumped. I don&#039t want to write a 2000 line if/then/end if statement, but I have a decompression dive table that would give results based on depth AND time but there are just too many varioations (i.e. 10 feet & 30mins to 160 feet & 5 mins) I can&#039t figure out how to pass it to an array to check. Excel has a "lookup" equation that will look at an array/table... anyone have any ideas?