| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can I create a formula to find a specific value within a group of.
I need to find an effficient way to find a specific value within a set.
Using the "OR" function is cumbersome and limiting. |
|
#2
|
|||
|
|||
|
depending on what it is you want to return a couple of functions spring to
mind, namely: MATCH LOOKUP VLOOKUP INDEX .... if you'ld like to post back with more details we might be able to give a better answer. Cheers JulieD "nccpa13" wrote in message ... I need to find an effficient way to find a specific value within a set. Using the "OR" function is cumbersome and limiting. |
|
#3
|
|||
|
|||
|
I was having a problem with my vlookup function which would seem to be a
perfect solution. I have it figured out. Thanks JulieD, Mark H "JulieD" wrote: depending on what it is you want to return a couple of functions spring to mind, namely: MATCH LOOKUP VLOOKUP INDEX .... if you'ld like to post back with more details we might be able to give a better answer. Cheers JulieD "nccpa13" wrote in message ... I need to find an effficient way to find a specific value within a set. Using the "OR" function is cumbersome and limiting. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a formula where high and low numbers are excluded | Excel Discussion (Misc queries) | |||
| formula to extract specific data if match occurs | Excel Worksheet Functions | |||
| Use of the DSUM formula to find exact matches in datatables | Excel Worksheet Functions | |||
| Create a formula in Excel? | Excel Worksheet Functions | |||
| create a chart with a formula | Charts and Charting in Excel | |||
Linear Mode
