VLOOKUP help (possible format issue)
Check out for any spaces before or after the text....
=VLOOKUP(A23,'Current running April 2010'!$A$1:$Q$620,1,FALSE)
Try the below which will return the number of occurances of the word in the
other sheet.
=COUNTIF('Current running April 2010'!$A$1:$A$620,A23)
to return the name itself...
=IF(COUNTIF('Current running April 2010'!$A$1:$A$620,A23),A23,"Not found")
--
Jacob (MVP - Excel)
"Mark D" wrote:
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
|