You may need a macro.
You could try a bunch of If functions or VLookups with links to the
file you are pulling from, but if you want it to do a lot of checking,
you will probably need a macro of some kind.
Please be more specific as to what you are trying to do.
And turn off Caps Lock.

Szalapski


--
TommySzalapski
------------------------------------------------------------------------
TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561
View this thread: http://www.excelforum.com/showthread...hreadid=395489