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

 

[B4L4KS]

it worked, well uploading anyway

kristian

 

[VoG]

So it looks like you are trying to lookup a value corresponding to 0 - is that correct?

You need to show us the other sheets.

 

[Dryver14]

Are M15 to 15 numbers?

should you be doing

=Sum('Selection Menu P'!M15:O15)

 

[B4L4KS]

Hi again

had lunch sorry

i have realized that the formulas work in different cells, but not the cells that they are already in.

why is this

kristian

 

[Gerald Higgins]

Like VoG said in post #12, you need to show us the other sheets.
And specifically, the area containing the data that you think the formula should be matching.

By the way, no need to apologise for having lunch - I'm having mine right now

 

[B4L4KS]

here is the data requested.

menu data

orderform

selection menu p

menu data is all the prices and food
order form shows the user what they have ordered, which is from selection menu p

thanks

kristian

 

[B4L4KS]

didnt realise it didnt show up

menu data

order form

selection menu p

these are the three pages and the cells with data in them that is required.

thanks

kristian

 

[VoG]

In H12, for example, you have 0 not the name of a pizza. That is why it isn't working.

 

[VoG]

I suspect that the underlying reason is what appear to be merged cells. I think that

='Selection Menu P'!G15:I15

should be

='Selection Menu P'!G15