Niek,

The formula you posted works fine, but once it has been overtyped it
is lost. What I want is for a manually-entered value in cell A5 to be
the source to look up a value for B5, and a manually-entered value in
cell B5 to be the source to look up a value for A5.

If the user enters a value in cell A5, but then changes their mind
and enters a value in cell B5, your formula in cell A5 no longer exists
to look up the value in cell B5 (confused? :) )

I've got a working solution now with the Worksheet_Change event and
it's not as clumsy as I first thought. I'd still be interested in any
other solutions though.

Thanks,
Vindaloo


--
Vindaloo
------------------------------------------------------------------------
Vindaloo's Profile: http://www.excelforum.com/member.php...o&userid=32634
View this thread: http://www.excelforum.com/showthread...hreadid=531866