Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help for choosing from a set of values
I am looking for help for a formula that will look at a set of values in
three columns and return the value of the last cell with data. Example below. Hope this is not too vague. col1 col2 col3 Result 1 1 1 2 2 1 3 3 If col1=1, return 1 If col1=1 and col2=2, return 2 If col1=1, col2=0 and col3=3, return 3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
choosing off various lists | Excel Worksheet Functions | |||
Excel formula(?) for choosing only 1 cell.. | Excel Discussion (Misc queries) | |||
Choosing a formula to used based on a codition fulfilled | Excel Discussion (Misc queries) | |||
Choosing a value from a row with more than one condition | Excel Discussion (Misc queries) | |||
Choosing a date | Excel Worksheet Functions |