Thread: look up problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] durbat2@googlemail.com is offline
external usenet poster
 
Posts: 21
Default look up problem

Hi

I have a data table with batch durations along the top from 1 to 36
and start times down the side from 1 to 24. At each intersection of
batch duration (col) and start time (row) there is a value to be
interogated. How do I find the intersection value of a particular
duration (col) and start time (row)?

Hope this makes sense

Thanks
Martin