Define and Reference fixed data in a table
With your present configuration, you might try the "intersection operator",
which is a <Space.
=Bravo Dick
OR
=Dick Bravo
Will return 27
AS well as
=Alpha Harry
Will return 5
And
=Tom Charlie
Will return 17
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"RedHook" wrote in message
oups.com...
Thanks Ardus - works great, although I had to use MATCH instead of
EQUIV for some reason.
|