vlookup formula problem

[mval]

Hi!! I am using this formulat to look up the value related to a number for example: I want to get the information related to this number 10A, so what I want is to be able to look for that number and populate the all the information to pertained to that number. this is what I am using: =VLOOKUP(A19,'J333'!$A$1:$F$599,3)

But the problem is that when I copied to the row belows, the information jumps around and also the result comes "#N/A" but there is info.

thanks for all you help!!

 

[pgc01]

Hi

You want an exact match and so you must set the 4th parameter of VLookup() to 0

Try:

=VLOOKUP(A19,'J333'!$A$1:$F$599,3,0)

Check the help on the 4th parameter.

 

[mval]

pgc01,


Thank you!! for the quick replied. So by adding 0 to the end of the formula would it look for exact match right? One more question, so what would be the different if I am using "TRUE" for approximate match, or "FALSE" for exact match?

Again thanks for you help!!

 

[pgc01]

I'm glad it's working.

If you use TRUE the lookup value does not have to be in the table. The help has several examples that clarify the use of the parameter.