Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search a value basing on another value
Col 'A' = Date
Col 'B' = Amount I am looking for a function for: Search if there is current month's date entry in Col'A', if found search for any entry in Col'B' of same row.If both conditions are true "Paid" else "Payment Due". Thanks to all Excel experts in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
transpose horizantal basing on cellvalue | Excel Discussion (Misc queries) | |||
copy and transpose basing on cell values | Excel Discussion (Misc queries) | |||
Basing one combo box on another | Excel Discussion (Misc queries) | |||
Basing Average function range on Date? | Excel Discussion (Misc queries) | |||
formula to calculate the average of a range basing on condition | Excel Worksheet Functions |