Morning everyone.

I have a simple VLOOKUP calculation which is causing me problems.

=VLOOKUP(A23,'Current running April 2010'!$A$1:$Q$620,1,FALSE)

A23 = persons name
Column 1 in the other tab is also a persons name. I just want it to return
the name in the cell.

I keep getting N/A appearing. But if I take the ''current running april''
tab and take the name from there are copy it into A23 it works. So I assume
it is something to do with the format of both cells.

I set both of them to TEXT, but that doesnt seem to be working

Any ideas??

Thanks