View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
RagDyeR
 
Posts: n/a
Default 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.