SUMIFS populate cell with value

I am using Windows 7 with Excel 2010. I need a to populate a cell in one worksheet with values from another worksheet using the following criteria.

This is for a employee training report.

Worksheet 1 will have a column for employee name. Also a row with task names. Below the task will be the achieved training level (X is for in training or a number value for the level achieved).

Work sheet 2 will be the individual employee report card. I would like to enter the employee name at the top of the report (in a single cell) and have the information from worksheet 1 for that employee only automatically populate the cells directly below the task name in worksheet 2. Again, so only that employees information is shown.

The formula for the cell below the task name in worksheet 2 will have to look for and match the employee name at the top of worksheet 2 with the employee name in the list on worksheet 1 and retrieve that data in that row matching the task name from both worksheets.

I don’t know what the best way (or any way) to do this is. Please help!!



By: John Nelson

19 thoughts on “SUMIFS populate cell with value

  1. ig

    Hi there, for all time i used to check blog posts here in the early hours in the dawn,
    as i enjoy to learn more and more.

  2. sling tv best package 2020

    Hey I am so glad I found your webpage, I
    really found you by accident, while I was browsing on Google
    for something else, Anyhow I am here now and would just like
    to say thank you for a marvelous post and a all round entertaining blog
    (I also love the theme/design), I don’t have time to read it all at the moment
    but I have book-marked it and also added your RSS feeds, so when I have time I will be back to read much more, Please do keep
    up the excellent b.

  3. sling tv

    I have been surfing on-line greater than 3 hours as of late,
    but I by no means discovered any interesting article like yours.
    It’s lovely price enough for me. In my view, if all web owners and bloggers made excellent content
    as you did, the net might be much more useful than ever

  4. sling tv

    Hi there! This is my 1st comment here so I just wanted to give a quick
    shout out and tell you I genuinely enjoy reading your blog posts.
    Can you suggest any other blogs/websites/forums that cover
    the same subjects? Thank you so much!

  5. vurtilopmer

    Hi there! This post couldn’t be written any better! Reading through this post reminds me of my previous room mate! He always kept talking about this. I will forward this article to him. Pretty sure he will have a good read. Thank you for sharing!

  6. ps4 games

    I like the helpful info you supply in your articles.
    I will bookmark your weblog and check again right here frequently.
    I’m quite certain I will learn many new stuff right here!
    Best of luck for the next!

  7. ps4 games

    Cool blog! Is your theme custom made or did you download it
    from somewhere? A theme like yours with a few simple tweeks would really make my blog stand
    out. Please let me know where you got your theme.
    With thanks

  8. ps4 games

    When someone writes an article he/she retains the thought of a
    user in his/her mind that how a user can know it.
    So that’s why this paragraph is amazing. Thanks!

  9. russia

    Hey, Ι think your website might be having broѡser compatibility issues.
    When I look at your blog site in Chrome, it looks fine but when opening
    in Internet Explorer, іt has somе overlapping.
    I just wаntеd to gіve you a quick heads up! Other then that, amazing blog!

Comments are closed.