| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple lookup function
Scott, If your data continues accross (A1:Z1=Country, A2:Z2=State, A3:Z3=Value) then you could use, =SUMPRODUCT((A1:Z1="US")*(A2:Z2="California")*(A3: Z3)) HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=563318 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Function with Multiple Conditions | Excel Discussion (Misc queries) | |||
| Lookup function gives wrong values occasionally | Excel Discussion (Misc queries) | |||
| Help with a lookup function that will give me multiple answers | Excel Discussion (Misc queries) | |||
| Multiple criteria LOOKUP | Excel Worksheet Functions | |||
| lookup function 1 | Excel Worksheet Functions | |||
Threaded Mode
