Results 1 to 2 of 2

How do I find matching values in different wkshts and copy corresponding cells.

Threaded View

  1. #1
    Registered User
    Join Date
    10-27-2009
    Location
    Arlington, Virginia
    MS-Off Ver
    Excel 2005
    Posts
    7

    Unhappy How do I find matching values in different wkshts and copy corresponding cells.

    I'm putting together a workbook that helps create a grocery list. There are 3 worksheets. The first worksheet (call it "meals") has a drop down box in cell A1 which lists all of the possible meals available by name. In cell B1 of "meals", you can choose if you would like the meal to be 300, 400 or 500 calories. The second worksheet (call it "ingredients") has all of the meals listed in column A, with the corresponding calories of 300, 400, 500 listed in Column B. Column C has the ingredients. What I'm trying to do is create a formula in the third worksheet (call it "grocery list") that finds what meal you have selected (cell A1 in worksheet "meals") and how many calories you would like that to be (cell B1 in worksheet 'meals") and it searches worksheet "ingredients" for an exact match. So it searches column A of worksheet "ingredients" to find the matching meal that was picked in cell A1 in worksheet "meals". Next, it takes how many calories you chose in cell B2 of worksheet "meals" and it finds that match in column B of worksheet "ingredients". Once it has matched the meal and calories, it copies the ingredients that are listed in column C to worksheet "grocery list".

    Is this possible without Visual Basic? or some other programming stuff?
    Last edited by needexcelhelp23; 10-27-2009 at 11:25 AM. Reason: New to forum, didn't follow rules

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1