why wont vlookup work

[B4L4KS]

Hi

When i use a vlookup even though it is correctly entered and all the data is correct, the outcome ends up being different to what it should be, also some of the boxes end up with Value and NA.

any help would be appreciated,

one of the formulas is below.

=VLOOKUP(H12,'Menu Data'!C12:D16,2)

many thanks

kristian

 

[JackDanIce]

I cant see anything inheritantly wrong with your formula. Can you post some examples of your data set and what the outputs should be and what you are getting?

 

[VoG]

Perhaps

=VLOOKUP(H12,'Menu Data'!C$12:D$16,2,FALSE)

 

[B4L4KS]

he VOG/ Peter

i have tried your vlookup example and it still results in NA,

Kristian

 

[VoG]

See if this helps http://www.contextures.com/xlFunctions02.html#trouble

 

[B4L4KS]

Hi VOG/Peter

the website was helpful but still doesn't work

Kristian

 

[VoG]

Try using Excel Jeanie to post a shot of your sheet http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

 

[B4L4KS]

hi

cant insert images im ustless

 

[VoG]

Please do not insert an image. Use Excel Jeanie - then we can copy from your post into Excel.

 

[Dryver14]

Are you copying VOG's formula exactly or are you inserting the spaces
you have in your first post