| View previous topic :: View next topic |
| Author |
Message |
Johan Planken
Newbie
Joined: 21 Nov 2003
Posts: 1
|
 Posted: Fri Nov 21, 2003 3:23 pm Post subject: VLOOKUP and HLOOKUP with offset = 0 |
 |
|
I want the next option(s), any one else ???
With VLOOKUP and HLOOKUP, when the offset is 0, give back the row or column number. |
|
| Back to top |
|
 |
dfrench
Moderator
Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand
|
| Posted: Sun Nov 23, 2003 8:41 am Post subject: |
|
|
| The MATCH function will return the position in the target array, |
|
| Back to top |
|
|
|
