Results 1 to 8 of 8

VLOOKUP - two criteria

Threaded View

erahi VLOOKUP - two criteria 09-15-2012, 05:19 AM
Ace_XL Re: VLOOKUP - two criteria 09-15-2012, 05:35 AM
erahi Re: VLOOKUP - two criteria 09-15-2012, 05:57 AM
oeldere Re: VLOOKUP - two criteria 09-15-2012, 06:02 AM
erahi Re: VLOOKUP - two criteria 09-15-2012, 06:44 AM
oeldere Re: VLOOKUP - two criteria 09-15-2012, 06:51 AM
erahi Re: VLOOKUP - two criteria 09-15-2012, 07:03 AM
oeldere Re: VLOOKUP - two criteria 09-15-2012, 07:06 AM
  1. #1
    Registered User
    Join Date
    05-17-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2007
    Posts
    23

    VLOOKUP - two criteria

    I've created an excel calorie counter and i need some assistance to add a few functions to make it even more useful. Currently I have a drop-down food list and I use VLOOKUP to fetch the required figures (carbs, protein and fats etc) for that selected food item and the portion size in grams. I want to add an additional list thats dependant on the food list. For example if i select 'Whole Eggs' then i want the second list to show the different egg sizes, Large, X-Large, Jumbo or if i select 'Apple' then i want the second list to to show, small, medium, large or if i select 'milk' then the second list to show cups, millilitres etc. I know how to create a dependant list, however my issue is setting up the required table/s to fetch the required figures. How would i go about doing this? I've attached the file on here. Any assistance is appreciated!
    Attached Files Attached Files
    Last edited by erahi; 09-15-2012 at 06:43 AM.

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