VLOOKUP problem

[jannerick]

I'm trying to use VLOOKUP. I think I have done everything correctly but it only seems to return the correct number sometimes. I'm using excel 2003. The rest of the time it returns the number at the bottom of the second column of the array. It's the most basic situation where you have two columns.

Anyone ever had this problem before...?

Thanks, hope that's enough info.

 

[VoG]

Try setting the fourth argument to FALSE. e.g

=VLOOKUP(A1,B$1:C$100,2,FALSE)

 

[p45cal]

Thanks, hope that's enough info.

…perhaps the formula you're using?

 

[jannerick]

the FALSE worked

thank you so much, you have really saved me a lot of time, it's kind of you guys to do this.