Re: sumif or if or something else????

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

Set up some named ranges:

Sizes covers the range of sizes that you have (eg Sheet1!$B$1:$M$1)
Types covers the range of types (eg Sheet1!$A$2:$A$100)
Table covers the numerical data in your table (eg Sheet1!$B$2:$M
$100)

Then you can use this formula (presumably in another sheet):

=INDEX(Table,MATCH(A1,Types,0),MATCH(B1,Sizes,0))

Hope this helps.

Pete

On Jul 11, 12:16 pm, durrienz <durri...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
Hi

I have a source table and a spreadsheet with 2 columns with pick lists.

Table1:

Type      Size1    Size2 (and so on)
type1     $10.00   $10.50
type2     $12.00   $13.50

Column1 from picklist (lists type)
Column2 from picklist (lists size)

Column3 should (if possible) show the corresponding value if 'type1 and
size1' as an example or any mix that is chosen...

Hope this makes sense?

Thanks for any help or guidance :)

.

Relevant Pages

  • Faster Prime class then Ruby 1.9
    ... previous thread where Antonio Cangiano provided the new and improved Ruby ... the code rebuilds the list of step sizes when the mathn.rb file is ... The step size calculation code could be moved to the initialize method, ... replaced by hard-coded lists. ...
    (comp.lang.ruby)
  • Re: code snippet
    ... Quite possibly, but it also has more overhead, and for some sizes of lists, ... computing the hash is more expensive than the entire search anyway. ...
    (comp.lang.c)
  • Re: Build regular expression from string
    ... the big sizes are) and wanted output. ... Which is the evident result of searching through the lists with $re as ...
    (comp.lang.tcl)
  • Re: Build regular expression from string
    ... Just give the input data (not too small, so that we can infer where ... the big sizes are) and wanted output. ... Which is the evident result of searching through the lists with $re as ...
    (comp.lang.tcl)
  • Re: Can INDIRECT function reference a cell that contains a formula
    ... "Biff" wrote: ... Let's take the bracket lists as an example. ... The exact formula that I entered in the data validation formula bar ... List the named ranges somewhere,say, G1:I1. ...
    (microsoft.public.excel.worksheet.functions)