| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up two values in different columns and return matching value
I am trying to create a lookup formula that looks up a value in one column
and then looks up a second value in the second column and returns the value in the third column corresponding to the two values. Eg, 1 3 45 1 4 56 2 2 34 2 5 67 Look up 1 in column 1 then 3 in column 2 and return 45 Please help -- Ash :) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup 3 matching values of which one is a range and return a sum | Excel Worksheet Functions | |||
| return values from an array based on matching text value | Excel Worksheet Functions | |||
| Return across Row Numeric Values Matching EXACT Month & Year for Criteria | Excel Worksheet Functions | |||
| Return Numeric Values Matching EXACT Date for Criteria | Excel Worksheet Functions | |||
| Return all matching values | Excel Worksheet Functions | |||
Threaded Mode
