Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need formula to create a value in a single cell by searching a range
I am attempting to create a value(an error message actually) in a single cell
by "searching" for a given value anywhere in a column or range of cells. The searched for value in the column is in response(via a formula) to certain criteria from other values in other cells within same row(using IF, OR, AND commands). Does anyone have a fomula that would help me? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need formula to create a value in a single cell by searching a range
You can use this formula as a guide...
=IF(COUNTIF(E4:H20,D1),"Value found in range!","Value not found!") Change the range to suit, D1 is assumed to contain the value you are searching for, or you can hard-code the value (example value 123) in like this instead... =IF(COUNTIF(E4:H20,123),"Value found in range!","Value not found!") -- Rick (MVP - Excel) "Stunzer" <u53932@uwe wrote in message news:9a7196c227c8a@uwe... I am attempting to create a value(an error message actually) in a single cell by "searching" for a given value anywhere in a column or range of cells. The searched for value in the column is in response(via a formula) to certain criteria from other values in other cells within same row(using IF, OR, AND commands). Does anyone have a fomula that would help me? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need formula to create a value in a single cell by searching a range
Rick,
Awesome, worked well & is exactly what I needed...thanks for the quick response also... Stu Rick Rothstein wrote: You can use this formula as a guide... =IF(COUNTIF(E4:H20,D1),"Value found in range!","Value not found!") Change the range to suit, D1 is assumed to contain the value you are searching for, or you can hard-code the value (example value 123) in like this instead... =IF(COUNTIF(E4:H20,123),"Value found in range!","Value not found!") I am attempting to create a value(an error message actually) in a single cell [quoted text clipped - 5 lines] commands). Does anyone have a fomula that would help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching for values in a given range and then prepending a formula | Excel Programming | |||
Create Macro to copy a formula to range of cell | Excel Programming | |||
create formula to compare cell 1 with a range of cell | Excel Programming | |||
Can I create an IF formula for single cell w/ dif. text in Excel? | Excel Discussion (Misc queries) | |||
Range.Find returns cell outside of range when range set to single cell | Excel Programming |