The reason i ask is because my table needs to look up in two areas for
marketing reasons e.g name is fine, but i would like people with the
postcode of #### to show up and then i can achieve a marketing campaign
on these results like you said kassie the postcode is on a "if required
basis" i had a look at the tip Bondi gave me and it worked well thanks
for the advice all


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=548238