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!

Hi

pls rewrite your fomula as below. it helps to get coorect answer

=VLOOKUP(C2,Calorietabel!A2:G10000,4,FALSE)

by seeting argument "False" it finds the exact match

Prashantha

Thanks, it worked!