Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have several columns in a spreadsheet in Excel and need to find the rows that contain the value Y in column B (CWI in example below), then print out the value of another column (e.g. Column A; Job Number in the example below) so then I can relate this to some paperwork that I need to extract data from. My spreadsheet looks like this:

Job Number | CWI | LI
-----------+-----+---
1114       | Y   | N
-----------+-----+---
1115       | N   | N
-----------+-----+---
1116       | Y   | Y

Is there some kind of script/formula I can use to iterate through all the rows and search for a value in column CWI then list the Job Number again in another column?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Put this in D1:

=IF(B1="Y",A1)
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.