Results 1 to 4 of 4

VLOOKUP problem

Threaded View

  1. #1
    Registered User
    Join Date
    06-23-2013
    Location
    Belgium
    MS-Off Ver
    Mac 2011
    Posts
    7

    VLOOKUP problem

    Hello,

    I've been trying to make a little workbook to make a diet. I've been using Google alot, but can't find a solution for my problem (I'm not very experienced with Excel).

    I have 1 sheet with some products on it, providing product name and all nutrition values next to it. On my other sheet I made a dropdown menu to choose a product. I want all the nutrition values to come next to it.

    I'm trying to do this using VLOOKUP and I finally managed to make the formula working (without showing N/A's). However, I did notice that the returned values are not accurate. When I choose a product it sometimes returns the nutrition values of another product..

    Does anyone know how I could make the VLOOKUP formula more accurate?

    I added the workbook to the attachments.

    Thanks in advance!
    Attached Files Attached Files

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