| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return value in 3rd column based on 2 other columns
I have a worksheet with 3 columns. I would like to return the value of column
C to another worksheet based upon the values in Col A & B. A B C 21057 1 63.50 21057 2 26.40 21057 3 44.80 21463 1 12.50 21463 2 38.50 21463 3 55.80 If A = 21463 and B = 1 then return 12.50. Maybe use vlookup? I know this is probably easy, just can't think of the solution. Thanks, Joe M. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup based on 2 columns; return 1 value | Excel Worksheet Functions | |||
| Lookup 3 columns and return a result from another column | Excel Discussion (Misc queries) | |||
| Add up a column based on values in other columns | Excel Worksheet Functions | |||
| looking up values in 1 column based on 2 other columns | Excel Worksheet Functions | |||
| Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
Threaded Mode
