"Nordic" wrote:
How do I lookup text in a column and have it enter text in another column?
For example, column P has Title and Regular in it. I want to lookup Title
and have an X recorded in column B in the corresponding row.

Maybe ..
In B2: =IF(TRIM(P2)="Title","X","")
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---