ExcelBanter - Lookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Lookup (https://www.excelbanter.com/excel-discussion-misc-queries/186047-lookup.html)

Nordic

Lookup

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.

Max

Lookup

"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
---

All times are GMT +1. The time now is 03:24 AM.