Excel formula for autofill information

B

blitzz008

Hello Experts,

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

Basically I have certain agents that manage cases. I get th
information of the cases each of the agents have and paste it in a ta
on my file. Once this happens I would like to automatically fill i
some columns and rows for each agent.
For example in the RAW tab is where I paste the information, I woul
like excel to search for the agent in the D column and if it matche
the agent in the tab, to search for the matching row in column A an
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=4665
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excell formula that autofills information 2
AUTO-POPULATE WORKBOOK WHEN OTHER WORKBOOKS ARE CHANGED 0
Mail merge w/Excel & Outlook 4
Look Up Formula With Veried Search Range 2
Index/match across multiple columns? 16
Macros to Rearrange Data?? 2
Formula autofill to cells below – formula arguments are cell areas in different columns 1
designing a macro 3

Top