I have a table that looks like the following:

100 200 300 Z1
400 500 Z2
600 Z3
700 800 900 Z4

Then on another worksheet the following:
100
200
300
400
500
600
700
800
900

I would like to do some sort of lookup to find which Z goes with each number.
So that my final table would be:
100 Z1
200 Z1
300 Z1
400 Z2
500 Z2
600 Z3
700 Z4
800 Z4
900 Z4

Thanks for any input!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200911/1