Hello all

I want to extract data to a cell from a ws bthat looks like that:

NEWYORK 99999 USA
LA 88888 USA
BERLIN 77777 EUROPE

I have 220 lines like this which is my "database".

I want to be able to punch-in "99999" and that in the next 2 cells it
will give me "NEWYORK" "USA"

Don't know VBA. two left hands and sounds like chinese to me :(

any help?


--
yadaaa
------------------------------------------------------------------------
yadaaa's Profile: http://www.excelforum.com/member.php...o&userid=35130
View this thread: http://www.excelforum.com/showthread...hreadid=548862