+ Reply to Thread
Results 1 to 8 of 8

VLOOKUP - two criteria

Hybrid View

  1. #1
    Registered User
    Join Date
    05-17-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2007
    Posts
    23

    Re: VLOOKUP - two criteria

    ive manually typed it up to show you what id like to see. If i select Whole egg then i want the second dependant list to show 'Jumbo, X-Large, Large' or if i select Apple then i want the second list to show 'small, medium large, etc. then id type in the portion size number 1 or 1.5 or 2 for that particular item

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: VLOOKUP - two criteria

    If you don't add the values in the sheet, i can't make a formula to find them (because, they don't exist).

    I know how to create a dependant list, however my issue is setting up the required table/s to fetch the required figures
    You can use this to fill the sheet.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ Reply to Thread

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