Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
up vote 1 down vote accepted

Put this in D1:

share|improve this answer

Your Answer


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.