| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Search a value basing on another value
On May 21, 9:37*pm, TUNGANA KURMA RAJU
wrote: 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. If you are looking for an actul search then you will ahve to do this by putting in a little code. If not you can copy this into a worksheet and it should give you the answer. =IF(AND(MONTH(A21)=MONTH(TODAY()),MONTH(TODAY())=M ONTH(B21)),"Paid","Payment Due") Hope this helps, Jay |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Search a value basing on another value
Mr.jlclyde,
Col"b" is a numeric value,not a date.please read my question thoroughly. yuor formula is entirely wrong. "jlclyde" wrote: On May 21, 9:37 pm, TUNGANA KURMA RAJU wrote: 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. If you are looking for an actul search then you will ahve to do this by putting in a little code. If not you can copy this into a worksheet and it should give you the answer. =IF(AND(MONTH(A21)=MONTH(TODAY()),MONTH(TODAY())=M ONTH(B21)),"Paid","Payment Due") Hope this helps, Jay |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Search a value basing on another value
Try this in C2:
=IF(AND(A2<"",MONTH(A2)=MONTH(TODAY())),IF(B2<"" ,"Paid","Payment Due"),"") Copy down as appropriate. Hope this helps. Pete On May 22, 3:37*am, TUNGANA KURMA RAJU wrote: 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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Search a value basing on another value
thanks pete.its working fine
"Pete_UK" wrote: Try this in C2: =IF(AND(A2<"",MONTH(A2)=MONTH(TODAY())),IF(B2<"" ,"Paid","Payment Due"),"") Copy down as appropriate. Hope this helps. Pete On May 22, 3:37 am, TUNGANA KURMA RAJU wrote: 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. |
| Reply |
| 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 | |||
Linear Mode
