[BC] One for the spreadsheet junkies....

[Cowboy]

 How do I.....

 Look up a value in a two dimensional table ?

 Say I have a table 10 cells wide by 10 cells high.

 From various other manipulations, say cell G5 has a value, and G6 has
 a value, which are labels for the table row and column.
 I want G7 to contain the results of a look up into the
 table at column label G5 value and row label G6 value ?

 The table is located elsewhere on the sheet, say row A3001 to row A3010
 and columns B through K. The labels live in row 2999 and column A.

 I know this can be done, but I've never had to do it.
 Anyone THAT good with a spreadsheet ?

 Thanks....

-- 
Cowboy

http://cowboys.homeip.net

Fine day to throw a party.  Throw him as far as you can.