Look up a column and return a value 1 cell below the word yes

**Martin Chamberlin** · 10-01-2013, 01:52 PM

Can someone give me a formula please that looks up a column of data and finds the word Yes, then returns the value in the cell below Yes.

Thanks in advance

Chambo

**Pete_UK** · 10-01-2013, 01:54 PM

Try this:

=INDEX(A:A,MATCH("Yes",A:A,0)+1)

Hope this helps.

Pete

**Martin Chamberlin** · 10-01-2013, 01:58 PM

INDEX(A1:A20,MATCH("Yes",A1:A20,0)+1)

Thanks Pete, does that mean the above. Neither formula are working

**Pete_UK** · 10-01-2013, 02:18 PM

Your formula is the same, but just covers the range A1:A20. However, the first range in the formula should be offset by 1 and then you don't need the +1, like this:

=INDEX(A2:A21,MATCH("Yes",A1:A20,0))

What does "not working" mean? Are you getting errors returned, or the wrong values? Please post an example workbook so I can see what's happening.

Pete

**Martin Chamberlin** · 10-01-2013, 03:32 PM

Thanks Pete, it works in a fresh spread sheet. Not sure whats going on with the original so wont send it in case it has a cold or something.

Best Regards

Chambo

**Pete_UK** · 10-01-2013, 03:46 PM

Okay, Martin. Understood. Glad you got it working.

Pete

Look up a column and return a value 1 cell below the word yes

LinkBack

Thread Tools

Rate This Thread

Display

Look up a column and return a value 1 cell below the word yes

Re: Look up a column and return a value 1 cell below the word yes

Re: Look up a column and return a value 1 cell below the word yes

Re: Look up a column and return a value 1 cell below the word yes

Re: Look up a column and return a value 1 cell below the word yes

Re: Look up a column and return a value 1 cell below the word yes

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Look for a value in word string in column data and return the same value

Cateorgise data - If word is in column H, return set value in blank column

If one column cell contains "y", return corresponding column word

Excel 2007 : Look up of a word in a column of URLs and return the URL.

need formula to search column for a word and return another word

Bookmarks

Bookmarks

Posting Permissions