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

[Chris Clark]

>From your description of your situation, the closest thing I can figure out
is VLOOKUP() or HLOOKUP(), or a combination.
It's been about 3 years since I used either of those functions, so I'm not
totally coherent at how they work exactly anymore, but I can tell you it
will take some playing around to get right.

I can't see any other functions off hand that would help, but if you go to
Add Function, and pick Lookup & Reference from the drop down menu, and see
if anything else there will help you.

Chris


On 2/16/06, Cowboy <curt at spam-o-matic.net> wrote:
>
>
> 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.
>
>
> _______________________________________________
> This is the BROADCAST mailing list
> To send to the list, email: broadcast at radiolists.net
> For sub changes, archives and info on this other lists:
> http://www.radiolists.net/
>



--
Christopher Clark
Production Technician -- Unistage, Inc.
Entertainment Technician -- Six Flags Darien Lake
Engineering Czar -- WITR-FM, Henrietta
Technical Director -- Wyoming County 4-H Theater Crew