| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Vector lookup function
Tried vlookup and reveiwed the others. Setting to false then requires an exact match. What I need is to find let's say 10 in data of a sinusoidal wave and refernce the time of occurance. I will accept as close to 10 as possible within the specified time frame. The data within that time frame might be ascending or descending. All lookup functions state data must be sorted or you can change to false and if not an exact match will return #NA. -- GregTh ------------------------------------------------------------------------ GregTh's Profile: http://www.excelforum.com/member.php...o&userid=16085 View this thread: http://www.excelforum.com/showthread...hreadid=275365 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Averaging function | Excel Discussion (Misc queries) | |||
| Function in XL or in VBA for XL that pulls numeric digits from a t | Excel Discussion (Misc queries) | |||
| Excel function help facilities | Excel Discussion (Misc queries) | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
| need to save values from a function before it changes | Excel Worksheet Functions | |||
Threaded Mode
