Oh, yes, MATCH! I knew I should know this.
MATCH by itself will do exactly what I want. For some reason my brain froze.
Thanks, Garry. :-)Glad to help!
I use MATCH() to return the position of a marker, then use INDEX() to return a
value. This works similar to a lookup function when the lookup value is unknown.
--
Garry
Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 307 |
Nodes: | 16 (2 / 14) |
Uptime: | 49:51:51 |
Calls: | 6,911 |
Calls today: | 1 |
Files: | 12,379 |
Messages: | 5,429,832 |