Hello Experts,

I am attaching an excel file with what I would like to do and with what
I think is 'half' of the formula.

Basically I have certain agents that manage cases. I get the
information of the cases each of the agents have and paste it in a tab
on my file. Once this happens I would like to automatically fill in
some columns and rows for each agent.
For example in the RAW tab is where I paste the information, I would
like excel to search for the agent in the D column and if it matches
the agent in the tab, to search for the matching row in column A and
then paste the case number in Tab John Column B Row 8, and so on.

I hope this is clear, if not please let me know.

Thanks a bunch !


+-------------------------------------------------------------------+
|Filename: example.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4688 |
+-------------------------------------------------------------------+

--
blitzz008
------------------------------------------------------------------------
blitzz008's Profile: http://www.excelforum.com/member.php...o&userid=33693
View this thread: http://www.excelforum.com/showthread...hreadid=535681