Excel 2007 : [SOLVED] VLOOKUP problem

[quaint_paradox]

This one works like it should.
=VLOOKUP(D16;L15:M19;2;FALSE)

This one does not:
=VLOOKUP(D17;L15:M19;2;FALSE)

Why? The first one was created yesterday and the last one today.

[arthurbr]

What do you mean by : this one works, this one does not? What error do you get?

[quaint_paradox]

I am sorry,
It is the value not available error, #N/A

[arthurbr]

Well if the value is not available that is what you get. Maybe post a sample of your data
Could it be that you dragged your formula down without using absolute refernces, so that L15:M19 became L16:M20 ? if so use $L$15:$M$19 and drag down as needed

[quaint_paradox]

what is the best way to post a sample data from excel to this forum?

[arthurbr]

Edit your original post - click go advanced - click the paperclip and follow the wizard (also read the FAQ)

[quaint_paradox]

Actually it started to work even though there was that error message. Tried again with another exercise and it worked flawlesly. Is it common in excel that weird things happen. I will give you star because you replied fast. Thank you

[abousetta]

Vlookup need exact (not similar) matches between the value being looked up and the reference list (first left column in your lookup table). Even a leading or trailing space will not give similar results. Also if they are numbers saved as text then they both (the lookup value and reference list) have to be saved as text.

Hope this helps.

abousetta

P.S. If you are satisifed with the results, then please mark the thread as Solved.

[arthurbr]

Is it common in excel that weird things happen

Nope, the problem is usually " finger trouble"