Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
A B C
1 Country Rev Class Sales 2 (Denmark) 1 139,403.82 3 (Denmark) 2 179,950.00 4 (Finland) 1 10,633.44 5 (Finland) 2 40,297.50 6 (Norway) 1 143,035.28 7 (Norway) 2 109,740.00 I want to return the sales value where country = "Denmark" and rev class ="2" (in other words cell "c3") I am usiing windows 2003 -- thanks ah |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
lookups referring to formulas | Excel Discussion (Misc queries) | |||
Double Lookups | Excel Worksheet Functions |