It should work ok. Pl try again.
Type say, the number 49 into all 11 source cells in X, viz:
Y8,AA8,AB8,AC8,AL8,AW8,BJ8,BN8,BO8,BQ8,BR8.
and H8 should return: NGP
Enter the letter: R in all 11 cells,
H8 should return: R, and so on
Also, ensure that calc mode is not set accidentally to Manual. Click Tools
Options Calculation tab
Ensure Automatic is checked
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DavidB" wrote in message
...
Yes I have followed your instructions and sorry Max but H8 in sheet X only
displays "Undefined" no matter what values I type in into
Y8,AA8,AB8,AC8,AL8,AW8,BJ8,BN8,BO8,BQ8,BR8.