Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Sumif | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |