| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup
How do i lookup with 2 criteria..
I have the date in column A, column b i have the region (ex Region 1), and i want to return whats in column C. =LOOKUP(TODAY(),Auto!A:A,Auto!C:C) i need it to be more like =LOOKUP(TODAY() & b:b Region1,Auto!A:A,Auto!C:C) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Another way to lookup data | Excel Worksheet Functions | |||
| lookup more than one cell | Excel Worksheet Functions | |||
| Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Threaded Mode
