Thankyou Benjielop, you formula is perfect, I will play around with it
to reflect different cells in sheet 2. The following question is not
important, however if you could assist me on the following.
If I input an incorrect post code understandibly I will get error #n/a,
how could I amend formula to show some brief text to state postcode not
found?
Once again thank you for your time
Porirua


--
Porirua
------------------------------------------------------------------------
Porirua's Profile: http://www.excelforum.com/member.php...o&userid=24505
View this thread: http://www.excelforum.com/showthread...hreadid=381022