Pull data from looking up from two different worksheets

[JKralick]

I have one worksheet that lists employees and plans, and I have another worksheet that lists the costs per plan and the portion paid by employee. What formula can I use so I can pull the costs for each employee in another worksheet? The employee worksheet will be updated as new employees are added/deleted and the cost worksheet will be updated as plan costs change each year.

Thank You

[arlu1201]

Hello JKralick,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

[Doc.AElstein]

I have one worksheet that lists employees and plans, ,,,,,

Hi JKralick
Welcome to Excel Forum

This is just the Sub Forum to say hello

You must start a new Thread here if you need help:

http://www.excelforum.com/excel-general/
or here:
http://www.excelforum.com/excel-formulas-and-functions/
or if you would consider a macro solution then here:
http://www.excelforum.com/excel-programming-vba-macros/

_............................................

Please, if you get time, take some time before posting to read the Forum Rules here
http://www.excelforum.com/forum-rule...rum-rules.html
http://www.excelforum.com/forums-rules/
It is usually worth it in the long run.

Thanks

_..............................................

P.s. Unless someone is very familiar with having done something exactly as you are doing, then I think you may need to give a bit more detail. Some test data is helpful
Remember to reduce the amount of test data to the minimum required to demonstrate typical scenarios. Desensitize the data if necessary.
Show us clearly what you have and the results you want to achieve.
Please do not use images as we cannot copy them to a worksheet.

Please
Either:
Post screenshots COPYABLE to a Spreadsheet: – See my signature below,
or here:
http://www.excelforum.com/excel-prog...ml#post4399581
Practice here:
http://www.excelforum.com/development-testing-forum/

OR:
Upload a Workbook: See here:
http://www.excelforum.com/the-water-...his-forum.html
http://www.excelforum.com/suggestion...ml#post4335120
OR:
There is also the file share site option such as this free thing:
https://app.box.com/signup/personal
(_ .Remember to select Share after uploading and give us the link they provide if you use that )
But Note: a lot of people can’t / won’t download a File from an external site. So this method is not preferred here
For security reasons and to increase your chances of a response, It is preferable to upload a File with no codes in it and post any codes in the Thread ( using Code Tags # )

OR:
Select the table Icon above, select an appropriate size table and fill it in (If replying to a Thread you may need to select the Go Advanced Button, ( bottom right of reply Window ) to get the Table Icon to show )


Practice Posting techniques here: ( Title your Thread something like: "Just test Posting, No Reply needed )
http://www.excelforum.com/development-testing-forum/

Thanks,
Alan