Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
define a range that equals the first row of another range
I want to create my own function that is similar to vlookup, but also uses
match function. My understanding is that there is no way to embed worksheet functions within another worksheet function, so I will have to perform the 'match' and 'vlookup' functions separately. In only want to have to import one lookup range for both the vlookup and match functions. Since the vlookup range will include the match range, I am looking for a way to extract the first row. That is match-range equals first-row-of-vlookup-range. How can I define a range that equals the first row of another range? -- Richard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AVERAGE a range in a column if another column's range equals a val | Excel Discussion (Misc queries) | |||
Determine if any Cell in Range Equals a String | Excel Programming | |||
if a:a (range) equals january and c:c equals gas then add g:g ($) | Excel Worksheet Functions | |||
Define a range based on another named range | Excel Worksheet Functions |