cells don't work

[B4L4KS]

hi

i have a similar problem to an existing thread last week, except that the problem i have is when i use "= and the cell reference" all i get it the answer "0"

any ideas on the problem, i also have REF and VALUE that appear sometimes as well.

the first image is the problem and the second is what should be in the cell, although the information in the cell is from a drop down box,

thanks

kristian

 

[VoG]

It should reference a single cell, like

='Selection Menu P'!G15

 

[B4L4KS]

hi

i forgot that i was trying to reference more than one cell, thanks, also why does vlookup always end up wrong, giving me a different price to what should be there,

thanks

kristian

 

[VoG]

Try

=VLOOKUP(H12,'Menu Data'!C11:D15,2,FALSE)

 

[B4L4KS]

thanks again

why is it the simplest things that are always wrong or cause a formula to malfunction

thanks

kristian