I have tried desperately to figure this out myself and avoid asking .... but!

Problems with a VLOOKUP function.

I have two columns (F7:F500 & G7:G500) performing a lookup into another worksheet (CallSigns) for data also in adjacent columns.

If I put the following in the cells (and a value in A7) it works perfectly except when it does not find a match, then it gives me the nearest value which is no good. I need an exact match or a return of #N/A:

(F7) =IF(A7>0,(VLOOKUP(A7,CallSigns!$A$1:$D$1000,2)),"")

(G7) =IF(A7>0,(VLOOKUP(A7,CallSigns!$A$1:$D$1000,3)),"")

So after reading the book/forums I added the following:

(F7) =IF(A7>0,(VLOOKUP(A7,CallSigns!$A$1:$D$1000,2,FALSE)),"")

(G7) =IF(A7>0,(VLOOKUP(A7,CallSigns!$A$1:$D$1000,3,FALSE)),"")

Now the return in (F7 etc) works perfectly (and gives "#N/A" if no value).

But the formula will not enter correctly into cell (G7), the cell displays the formula text no matter what I do. I have looked at formatting, including copying/dragging from other good cells but no result.

If I put the following:

(F7) =IF(A7>0,(VLOOKUP(A7,CallSigns!$A$1:$D$1000,2,FALSE)),"")

(G7) =IF(A7>0,(VLOOKUP(A7,CallSigns!$A$1:$D$1000,3)),"")

Now the return in (F7 etc) works perfectly (and gives #N/A if no value).

Now (G7 etc) works fine except when it does not find a match, then it gives me the nearest value.

Is the problem to do with using multiple formula with FALSE statements/results or am I up the wrong tree?

Thanks,

Mike