Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Confirming Vlues in 2 Cells Appear in a List
I have a quick and hopefully simple questions.
I have a source list of data (for example): BLR1 SL1 10000 BLR2 SL2 20000 BLR3 SL3 30000 BLR4 SL1 30000 In another list, I have two input conditions in two different cells: SL1 20000 x I'd like a third cell where the 'x' is to tell me if I have already have that combination in the source list. If so, indicate with a 'y'; if not; indicate with an 'n'. The input above would indicate an 'n', an entry of SL3, 30000 would indicate a 'y'. The source data field may be random and not sorted in any particular order. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Confirming Vlues in 2 Cells Appear in a List
Assuming that A2:C5 contains your data, try...
=IF(SUMPRODUCT(--(B2:B5=E2),--(C2:C5=F2)),"Y","N") ....where E2 contains the first criteria, such as SL3, and F2 contains the second criteria, such as 30000. Hope this helps! In article , Jamie M <Jamie wrote: I have a quick and hopefully simple questions. I have a source list of data (for example): BLR1 SL1 10000 BLR2 SL2 20000 BLR3 SL3 30000 BLR4 SL1 30000 In another list, I have two input conditions in two different cells: SL1 20000 x I'd like a third cell where the 'x' is to tell me if I have already have that combination in the source list. If so, indicate with a 'y'; if not; indicate with an 'n'. The input above would indicate an 'n', an entry of SL3, 30000 would indicate a 'y'. The source data field may be random and not sorted in any particular order. Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Confirming Vlues in 2 Cells Appear in a List
Just what I was looking for! Thanks!
"Domenic" wrote: Assuming that A2:C5 contains your data, try... =IF(SUMPRODUCT(--(B2:B5=E2),--(C2:C5=F2)),"Y","N") ....where E2 contains the first criteria, such as SL3, and F2 contains the second criteria, such as 30000. Hope this helps! In article , Jamie M <Jamie wrote: I have a quick and hopefully simple questions. I have a source list of data (for example): BLR1 SL1 10000 BLR2 SL2 20000 BLR3 SL3 30000 BLR4 SL1 30000 In another list, I have two input conditions in two different cells: SL1 20000 x I'd like a third cell where the 'x' is to tell me if I have already have that combination in the source list. If so, indicate with a 'y'; if not; indicate with an 'n'. The input above would indicate an 'n', an entry of SL3, 30000 would indicate a 'y'. The source data field may be random and not sorted in any particular order. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop-down list & auto-population of cells | Excel Worksheet Functions | |||
change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
List box, copy multiple Cells | Excel Worksheet Functions | |||
Data Validation List Option Affecting Other Cells? | Excel Worksheet Functions | |||
make list of information from different cells | Excel Worksheet Functions |