Need to find the value within a matrix / table based on two other values

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have a 9 x 10 table in excel that holds txt strings e.g "BRC",
"BPC". There are 9 rows and 10 columns. Outside of this size table, I
have headings for each column and row (so it is a 10 x 11 table if you
include the row and column names). Each cell within the table has a
corresponding row and column heading name e.g row 1's name is OFF, row
2 is WT_STEDY.....column 1 is Blend Closed, column 2 is Steady State.
There is a text string that goes with each combination of heading
names e.g. the string for row 2 and column 1 (WT_STEDY, Blend Closed)
is "BRC".

I would like to be able to feed the names of the two corresponding
heading names into some kind of lookup formula that will then return
me the string of the cell in the matrix to which they both correspond.
The heading names would themselves be fed from two cells elsewhere in
the spreadsheet. How do I go about doing this?

Regards,

Tom Pritchard

.

Relevant Pages

  • Re: Inserting data into Chart Heading
    ... concatenation to create the title text you want (concatenate is what ... you could compile the heading you want into a single string as ... formula in a cell in the worksheet, again using concatenation, eg ...
    (microsoft.public.excel.charting)
  • Re: how to "flatten" a list
    ... everything under that heading is a pretty common need. ... Function Concatenate(strSQL As String, Optional strDelimiter As String = ", ... Dim rs As DAO.Recordset ... Dim strReturn As String ...
    (microsoft.public.access.queries)
  • Re: generating dynamic heading images
    ... each corresponding to a letter in the string that is being ... > turned into a graphical heading. ... > find is the GD technique of FIR. ... > I need to - break a string apart an then count the individual letters ...
    (comp.lang.php)
  • Re: How can I group common parts of search keys in VB6?
    ... I'm assuming your comment assumes txt is an empty string, ... The heading should be Space Shuttles not Space, ... "Apples Are Good For You but only on Tuesdays" ... I reckon maybe a concordance index is the way to go. ...
    (comp.lang.basic.visual.misc)
  • String and number manipulation
    ... I am evaluating cells for heading and numbers, ... that in 90% of the cases the numbers are simply 5 digits long and can easily ... is that I am going to have to hold the value as a string - take the parts of ...
    (microsoft.public.excel)