| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
one of two criteria
Hi, i need a formula that retrieve data if one of two criteria is met. I need
the formula in "C". If A1 or B1=Sheet2!A1:D25,retrieve content of cell 3 Ex: Sheet 2: A B C John 32 AP Mary 28 TRP Jim 38 AP Sheet 1 A B C John =AP 28 =TRP Jim 38 =AP If one of two criteria is met, or if both criteria is met. Can this be done? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count how many criteria in a column match criteria in another colu | Excel Discussion (Misc queries) | |||
| EXCEL - Meet 2 criteria, then find next case of third criteria | Excel Worksheet Functions | |||
| =DMIN(database,field,criteria) question about criteria | Excel Discussion (Misc queries) | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Threaded Mode
