Posted by Allan on January 02, 2002 12:44 PM
I hope someone can help. I want to find a value in a table referencing information from a column and a row, so you can't use Vlookup or Hlookup as far as I can tell. For example I have a table that gives the number of reel changes on a print machine that varies due to page size (in a column) and batch size (in a row), the resultant table has varying numbers in it. So I want to reference the Page Size and the Batch size and get the relevent value from the table to use in another spreadsheet to calculate reel change waste.
I hope this problem makes sense as it seems simple but I've searched everywhere (including Microsoft!) but can't get an answer.